Create a new form for that purpose. One form cannot do everything. KISS
All I want to do is add or edit an inspection --> search for a piece of equipment to add to the inspection and then fill out a checklist for that piece of equipment
Create a new form for that purpose. One form cannot do everything. KISS
All I want to do is add or edit an inspection --> search for a piece of equipment to add to the inspection and then fill out a checklist for that piece of equipment
I thought you were going to use tblResults to do this.
frmChecklist populates tblResults, this is where the questions are displayed and the user answers the questions
tblChecklist holds the questions
tblResults stores EquipInspectID, the question and the answers so you know when a piece of equipment is in an inspection and what the answer was for a question
All I want to do is add or edit an inspection --> search for a piece of equipment to add to the inspection and then fill out a checklist for that piece of equipment
Your latest Form no longer works for me as I changed the Tables.
But all you need is ClientSite at the top of the form and InspectionID
In the Sub you use a Combo to select the Equipment which is filtered by ClientSite.
My thinking is not perfect at the moment as I am working on a project of my own. But we will bet there.
Filling out the checklist is done by code is it not.
Your latest Form no longer works for me as I changed the Tables Yes it is all broken for me as well
But all you need is ClientSite at the top of the form and InspectionID
In the Sub you use a Combo to select the Equipment which is filtered by ClientSite. Will work on this, not sure how to get both client and site together besides having a combo with both, however this is repetitive, or 2 combos one for each and record from second combo
My thinking is not perfect at the moment as I am working on a project of my own. But we will bet there. That is fine it is my own problem and don't let me take your concentration away from what you have to do for yourself
Filling out the checklist is done by code is it not. The checklist questions are displayed from tblChecklist and the last answers are displayed, however the user will be the one filling out the checklist and then all the values EquipInspectID, ChecklistID (question) and Answers will populate tblResults by code
It all works well in the oldversion I posted earlier today however can't seem to get it working properly in the new version
frmChecklist populates tblResults, this is where the questions are displayed and the user answers the questions
The Questions and answers should be loaded via Code after selecting the Equipment in frmInspections.
yes this is what I am trying to do