Open form to record question

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

Guest

First thanks for your time reading this,

I have a search form to find items on a subform of my main form. Right now
I have it set to onDoubleClick to open the form to the record with where
condition equals PID. Is there a way to open to the record but not have it
filtered as 1 of 1?

Pete
 
Yes, you can set the focus to the field that contains the value that you are
going to use to locate the desired record. Then use:

docmd.findrecord TheValueYouWantToFind

Where the "TheValueYouWantToFind" is, replae it with the value you are
looking for in the table. This will move you to the first record that
matched the value you provide for the "TheValueYouWantToFind"

Take a look in VBA Help for "FindRecord".
 
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

Access Main form/Subform Navigation 0
Open main and sub form blank 1
Pop-up form that creates record that links 1:1 to main form 0
form requery, first record problem 11
Use TextBox on the main form to limit SubForm 2
Access 2003 vs 2010 1
open form to specific record in subform 9
Continous Forms and preventing a new record being created 2

Back
Top