Limit list

[hzeigler4]

I have a form Called Work Order Entry that displays details about a work order. It contains a subform listing certain steps used for that work order. There is a button "Add more steps" Which pops up a form allowing them to enter a new step and it is then added to the step subform. I would like the Add More Steps form to omoit those steps that have already been used for this work order. Anyone got any ideas? See attached.

 

[hzeigler4]

Has no one had this issue? I made a query that gets a list of the unmatched steps. Problem is, I need it to look at the Work order to see which ones it has already used and nt sure how to do that.

Here is SQL from my query:
SELECT tblStep.StepNbr, tblStep.StepDesc, tblStep.StepHrs, tblStep.StepDlrs, tblStep.StepSkill
FROM tblStep LEFT JOIN tblWOstep ON tblStep.StepNbr = tblWOstep.WOstep
WHERE (((tblWOstep.WOstep) Is Null))
GROUP BY tblStep.StepNbr, tblStep.StepDesc, tblStep.StepHrs, tblStep.StepDlrs, tblStep.StepSkill
ORDER BY tblStep.StepNbr;