>i have a table with many fields. i need to be able to access the same record on more than one form and be able to edit that data. I am using text buttons class to control file updates, edits etc. i simply want to access the same data on a second form without opening and closing the table to do so. i have some strategies, but they seem to be way more complicated than they they should be(tons of overhead). there must be a simple solution. open to suggestions!
>thank you
>frank

Use Private DS in your forms. To edit the same record in both forms, what I have done is set a oApp property equal to the KeyID of the record I am editing. When the second form launches, I check the value of the oApp property. If it is not null, I do a seek on that key. If found, that is the initial record the form is opened with. If not found, the first record in the table is what I edit.

There is also the option of using a parameterized view of the table where the parameter is the KeyID. I then initialize the parameter [nKeyID = oApp.KeyID] then do a requery() on the view to retrieve the record.