MS Access - Forms

[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?

 

[Jeff Boyce]

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