Open specific record

J

Joe

How do i open a form with a command button and goto the
record i want based on criteria.
It has no record navigators or anything, just open the
one record I want. Thanks in advance.

Joe
 
H

Hugh O'Neill

Joe said:
How do i open a form with a command button and goto the
record i want based on criteria.
It has no record navigators or anything, just open the
one record I want. Thanks in advance.

Joe
Click to expand...


Base your Form on a Query that has the unique index of the record you
want as its criterion.

hth

Hugh
 

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

Copy previous record into form field 0
Adding data to MS Access from csv file 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Can I save a sql statement generated by a search form? 1
DLookup in Continuous form 0
Autonumber field in Excel that behaves the same as Access 0
Crating User Form to Add Names 1
Add New Record Button: How to Get Mouse Cursor in Specific Field Upon Clicking? 1

Top