Clear a Column?

[David Ebert]

I'm experiencing very strange behavior in a couple of forms.   I've place columns on the forms.  In edit mode, the client always comes up with values from the last record entered (any record, not one for that client).    In the application, the client and admission are selected first, the record numbers for the client and admission are set as global variables.  All data entry/edit functions use these two variables to either identify the existence of the record or the record itself.  The command file calling the form always clears the form variables.   However, even when I exit from the application rerun it, select a new client and admission, forms come up with the same values even though these are columns not variables.   This is saving wrong data to the tables.    Can anyone help me on what may cause this sort of thing?   Instead of picking the client and admission once up front should I change to a lookup on every form and clear all of the variables between functions?   tia   Dave