When a hidden form isn't hidden

[Beltronics]

I have an action script where I need to open a form to "set" some values using global variables. I set the action script to open the form in Hidden - Modeless form. I set a value, change to a different record, set a value (I do this twice), then I close the form. When I go thru debug, I don't see the hidden form but when I activate the action script "on push" from a button, I see the hidden form pop up and then go out almost immediately. Any suggestions as to what might be causing this? I find I can SET variables to values contained in a table without opening that table or a form for that table but, I can't figure out how to SET those values in the table using a global variable without opening the form, hence my problem above. I just want to get the value in the table, put it in a variable, change the variable and then go back and change the original value in the table with my new variable value.

[Steve Workings]

Re: When a hidden form isn't hidden

Sounds like you need some Xbasic help? Doing this with a form is unwieldy, at the least.

If your last sentence is a guide, and with no information on what you have to find the correct record, let me generalize:

to set the variable:

dim global myVar as C
t = table.open("mytable")
t.index_primary_put("myindex")
t.fetch_find(MyIndexValue)
MyVar = alltrim(t.Myfield)
t.close()

Now, I'm assuming your doing something here to change the variable value, so now that it's changed:

t = table.open("mytable")
t.index_primary_put("myindex")
t.fetch_find(MyIndexValue)
t.change_begin()
 t.Myfield = MyVar
t.change_end(.t.)
t.close()

Does that help?

[Beltronics]

Re: When a hidden form isn't hidden

Yes, that helps but let me play with it. I know that most of these questions are hard to figure out when you are at the other end. I have a chart of accounts. The table name is accts. In that chart of accounts, I have three records. Those records have a field called balance. One record for Cash, one for Savings, one for Checking. When I open one form called MENU, I run an action script which goes into that table and sets three global variables called vn_cash_balance, vn_check_balance, vn_save_balance. Then, on a "bank transfers" form, I display those three variables as the field values. Then, I have another variable on the form called vn_transfer. The operator enters a number and clicks on a transfer button to transfer from cash to checking or checking to savings. Then, when the operator accepts the action as viewed in a dialogue message box, I need to go back into accts and change the value in whichever two accounts the operator has changed. I need to write newvn_cash and newvn_check or newvn_save to the account records in accts and I don't want a chart of accounts form to pop up. I use action scripting because I am not well versed in xbasic. But, I can work with your examples and see where it gets me.