var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Selecting certain records from a table, and put into report
I have a very simple database with one table, which has a list of equipment, each with it's own unique ID.
I want to be able to select different pieces of equipment (i.e. by typing in the unique ID number) these different records will then be presented in a report.
How do I go about doing this?
Many thanks for your help and time
You can pass a criteria when opening the report:
Or if ID is not defined as a numeric value, you use:
DoCmd.OpenReport "ReportName", acViewPreview, , "ID IN ( 1, 4, 15, 19 )"
DoCmd.OpenReport "ReportName", acViewPreview, , "ID IN ( '1', '4', '15', '19' )"
Have a nice day!
Or, make your report based on a querry whose criteria is the different IDs you want reported on.