[Solved] Have query criterion questions present in a form

[marcdvincent]

Solved it myself - thanks

I have a data base that tracks jobs, each job has it's own Job Number. Each job is comprised of several sections which are numbers. Each Section has several sub sections which are also numbered. The Job Numbers are unique but the Section Numbers and SubSection Numbers are not (i.e. many jobs will have a "Section 1" or a "Section 2" etc.) Also each Section can have a "SubSection 1.1" or "Subsection 1.2" etc.)

I have created the tables so that the SubSection Table has the Child Key "SectID" in it, which is the Parent Key for the Section Table. Likewise, the Section Table has the Child Key, "JobID" which is the Parent Key in the Job's Table. The relationships have been established between the tables.

What I am trying to do is to create a table that lets me enter the SubSections for the Sections for any give job. I have already created a form to create the Job Number with an embedded subform to enter the Section Numbers. What I can't seem to figure out is how to create a form to enter the SubSections for each Section. What I want is to have the "Sect Number" field prompt me for the "JobNumber" and then based on that it only displays the Section Numbers related to that Job. I am able to create a query that does this (using the criterion ":Job_Number" in the Job Number field but when I link the form field to this query I get nothing.

Please Help

Thanks,
Marc