First combo box, jobtype is a simple drop down list (not linked to a table or anything)
The second one runns a query using data from a a table containing two columns; jobtype and job. The criteria in the jobtype field is
and I've set the bound column property to 2 to get the job column from the query.
Ideally, the results of this query should populate the combo box, but when I select it on my form (in form view) I just get an 'Enter Perimeter Vaule' dialog box.