Best way to update records on a form?

[Dryseals]

Hello again,

I have a subform in a tabular format that the users add and remove data. Also is the ability to renumber certian records. So I ran into a bit of a problem and need a quick fix (I leave for five days after today and do not want to be called at home, otherwise I would struggle through, always remember better).

A user was doing a copy and paste operation in a field and before the record was updated, they clicked the renumber button (code in the background). So the program thought there were two people accessing the same record at the same time. To avoid this happening again, I would like to put something behind the button to assure that the records are updated.

Would refreshing the form in the code first be the proper way?

 

[PHV]

Check the Dirty property of the Form object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Dryseals]

Thanks PHV, always wondered hopw I could use that. But I still have a question. If I check if it is dirty, what would be the best way to fix it, do a save I guess?