MS Access - Forms

  • Thread starter Thread starter Nicole
  • Start date Start date
N

Nicole

I have a form for data entry, when the data is entered in the form fields and
before I tab to enter the next record I want to print this information as a
label to be attached to a cardboard folder. The report I have created shows
all the records in the table attached to the form rather than just the record
on screen. How do I set the DoCmd.OpenReport function to just display that
record on screen?
 
Nicole

Use Access HELP to learn more about the syntax of

DoCmd.OpenReport

One of the components allows you to specify a "WHERE" clause ... that's
where you'd tell Access to open the report, but ONLY for the record (ID)
showing on the form.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top