Hello to all,

I am hoping someone can help and/or lead me in the right direction. I have a vehicle database created with basic info (unit no, make, model, license, etc..) I have a created a query within the database that when asked for a specific unit number [enter unit number] the query returns the unit number and other relevant data from that record. I have an inspection worksheet that I want all the information generated in the query to populate the worksheet cells from the results of the queried data. Ideally I wanted to input a unit number on the worksheet and have it hit the query in the Access database or just query the database and return the needed info into the defined cells in the worksheet. For example I would put 701 in the unit number cell of the worksheet, then ask the worksheet to do something...... import data, query, ?? and would then get the unit number and populate the other cells on the worksheet with the model, make, year, license, etc...


This is a two part question. The second task would be once the worksheet data was populated I would use the worksheet for the inspection which then after wanted to update a table within the same database. For example once the worksheet was populated with vehicle information in the previous step I would now use the worksheet to complete the inspection. I would then have the current inspection date, mileage, and inspection type information that I would want to add back into a PM Inspection table in Access. This table would continually be updated from the results of an inspection.

I do not have a lot of experience in Access but conceptually know what I want to happen. Hoping somewhere here could me.

Thanks
Todaychris