Right now, I have a form, locked records, on which I have a CommandButton that opens a second form (much like the first) but open for editing, plus allowing the user to manipulate other areas of the data base.
I want to have the second form open at the specific record I was working with on the first form.
Basically what I am doing is running a find to locate the record after the second form opens, as all I have is DoCmd code to open and close the forms. Both my forms are based on the same table [tblCompanyList] and I want to open the second one based on the [CompanyID], which is an autonumber, that is displayed on the first form.
I am using two forms so that I can control who has access to which parts of the db. If this makes sense.