Auto open Find Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way when a form is opened that the Find Record box opens up on a
field I want?
 
Kevin,

In the On Open event of the form:

Me![YourLookupField].SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

Sprinks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trick filter form combo with DoCmd.OpenForm and Data Entry property 2
Need help on auto pop time through a form 2
Going to first record 0
Separate Form 0
Prompt on Open 3
Linking Main form and sub-form to second form 2
Unbound Text Box Showing Wrong Number of Records 3
Go to specific record in a form PLEASE HELP ME :) 1

Back
Top