Pop-up Sub Report

[googalabosh]

I want to create a button that opens a subform based on the VIN of a vehicle. How do I do this?

Database Design Summary:

Table 1: Vehicles (Contains vehicle information to include VIN number)

Table 2: Maintenance (Contains logs of each time the vehicle was repaired or had general maintenance completed)

Form 1: Vehicle Overview (This is the primary form used to display and maintain the information for each record/vehicle. It displays general information about the vehicle.)

I want to put a button on Form 1 which opens a popup window with a subform containing a list each time that specific vehicle was maintenanced. It should look up these records via the VIN of the vehicle.



How do I do this?

TIA!

[Welshgasman]

Open the form using the where parameter of openform

[Micron]

I don't understand the notion of opening a subform in a popup window/form. The subform for vehicle details should be based on the VIN field from the main form and that subform should be on the main form. The VIN field should also be part of the subform so that the 2 forms are linked via Child and Master linked field properties. Whatever VIN is showing on the main form, the related maintenance records should be showing on the subform.