Opening a form at a specific record, based on another form control

[Martin Bentler]

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.

[trevor glover]

Hi Martin,

On the Toolbox toolbar (in the form you are using), use the Command button wizard, as you navigate through it you have an option to go to a specific record, which you can use both ID criterias to apply a filter.

Hope this helps you.

Trevor