By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,678 Members | 2,439 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,678 IT Pros & Developers. It's quick & easy.

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

P: 4
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.
Mar 24 '08 #1
Share this Question
Share on Google+
1 Reply


P: 6
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
Mar 25 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.