Open specific record

[NickW]

I would like to have a form that has an unbound text field, a user enters an
ID #, and have a button that will open a report with just that record
showing. How is this done?

 

[Allen Browne]

See:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

The example is a bound form, but it's identical for an unbound form (but
omit the 'save any edits' bit.)

 

[Al Campagna]

Nick,
I usually use a combo box for a "quick find." It can act just like a
text control, but can also prevent entering illegitimate IDs.
On my website (below), I have a sample A97 and A2003 downloadable files,
listed under "Combo Quick Find"
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Al Campagna]

Nick,
Sorry... I didn't see that you wanted to "report" on a record.
Thought you were just "finding" a record in a form's recordset.
Try Allen's suggestion... and post back here if you still have problems.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."