Here is a copy of my current database
Attachment 4779
If you go through frmMainMenu-->Select relevant combos and click on Add new Inspection-->fill in relevant details-->Add Equipment-->select equipment from combo box-->click in checklist form
The check-list form is populated with the questions for that specific piece of equipment type
What I want to be able to do is to default all the answers to the same answers that were recorded on the piece of equipment at the last inspection. Does anyone know how to do this with my current design?
This is extremely important for my system to work effectively and was thinking DLookup was the way to do it
If someone can give me a way to default one or 2 certain answers I may be able to figure out the rest
Thanks