Help with Parameter Query and Entry Form

[Def7]

I need some help setting up a form. I created a Parameter Query that returns back any Vehicle ID’s where certain criteria are not met. I then created a form where the different Vehicle ID’s can be entered and then a report in created base on this. I am trying to set it up so that I can enter Vehicle ID’s one at a time in the same box and somehow after every entry it creates a report that once all the Vehicle ID’s all imputed I can have the list generate a report. This will be a daily process in which different ID’s will be entered everyday. I have only been able to make it work by setting up the form with multiple boxes for each particular ID, but there can be up to 20 a day and I don’t want to have to set up 20 different boxes if it can be helped. Any help would be greatly appreciated.

 

[apr pillai]

You may create a Table (let us call it ParameterTable) to store the VehicleIDs and Create a Datasheet Sub-Form for the Table. Insert this Sub-Form into the Main Form. You can keep adding the Vehicle IDs as separate records in the Parameter Table.

Reference the VehicleID field of the ParameterTable in the Query Criteria Row in the following manner:

IN (SELECT VehicleID FROM ParameterTable)

This will select all the Records matching the Vehicle IDs in the Parameter Table from the Main Table for your Report.

Look for examples of Parameter Query at:
http://www.msaccesstips.com/2008/10/multiple-parameters-for-query.shtml