linking queries to unbound lookup on a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that looks at two boxes on a form one is linked directly to a
table the second is a lookup which brings back detail form anther table.

The first box is working but the query is failing to pickup the unlinked
list box.

(Access 2003)

SELECT tblScale.[Band], tblScale.Site, tblScale.Start
FROM tblScale
WHERE (((tblScale.[Band])=[Forms]![frmMain]![Min Grade]) AND
((tblScale.Site)=[Forms]![frmMain]![List80]));

Here is SQL of the query and all fields are correctly named.
 
On the After Update event of each combo (the 2 combo's) you need to refresh
the data in the third combo

Me.[ThirdComboName].Requery
 
Is List80 a Multi Select list box?
If so, it has no value. You have to use the ItemsSelected collection of the
list box and build a string to pass to the query.
 
Back
Top