Is this possible

[tmaleshafske]

So I am working on a database for work for the storage of maintenance records for equipment. Now most of the people that I work with aren't very computer literate so I am trying to make it as dummy proof as possible. What I am wanting to create is macro or script that once you add a record to a specific table it automatically creates the necessary queries and reports for that record. Is this possible? Using Access 2010

 

[Mr. B]

Please explain a bit more. Queries and reports are not normally record specific so I am not understanding what you are needing.

 

[tmaleshafske]

Well here is the basic layout that I have right now currently there are 2 major tables the equipment record table and the service record table

for each record in the equipment record table I have to have a seperate query and reports for that specific piece of equipment, but I want it to automatically create the query and report object upon add of any new record to the the equipment record table.

 

[Mr. B]

Create am unbound form. Add a combo box that will display a unique list of your equipment from the equipment table.

Use one of your existing queries or build a new on that returns the data you want but for the criteria, right click in the criteria and use the "Build" option and create a reference to the combo box on your form as the criteria. Save the query.

Open your form and select a piece of equipment and then open the query. If you have set it up correctly the query will return the information about the selected piece of equipment.

Base your report on this same query and you should have what you need,

 

[tmaleshafske]

Yep You got it I had completely forgot about filtering from a combo box Thanks