Subform Help

[Def7]

I am trying to create a form in which when a Vehicle ID is entered or searched a subform display all previous entries for that Vehicle. I have the Vehicle ID information in 4 different tables (Don't have a choice but to do that per boss) is there any way to make that happen with the 4 tables?

 

[apr pillai]

If all the four tables have the same structure and data type then create a Union Query to combine the data of all 4 tables together. Refer the following link if you need help with Union Queries:
http://www.msaccesstips.com/2008/02/union-query.shtml

Create a sub-form using the Union Query. Create a Main Form with a Text Box on the Header of the Form with the Name VehicleID and insert the sub-form into the detail section of the Main Form. Display the Property Sheet of the Sub-form and set the Link Master field property value as VehicleID and set the Link Child Field Property value to the Vehicle Id field name of the Child Form.

When you enter a Vehicle ID number in the Text Box in the Master Form all records matching this number will show up in the sub-form. You don't have to search for it.

 

[Def7]

This worked except that a pop up window comes up and that is the only way I can enter the Vehicle ID #. After I get the first set of information for a particular ID#, I am not able to enter any new number in the text box created. I have to exit the form and re-open to get the pop up box back. Is there anything I can do to fix this?

 

[Def7]

Ignore my post before I got it to work correctly. Thank you very much.