linking queries to unbound lookup on a form

D

DK

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.
 
O

Ofer Cohen

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
 
K

Klatuu

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query driven by form field 1
Using list box adds blank record to lookup table 1
Lookup not showing records, also captions not displaying correctly 4
unbound fields on a form 1
Combo Box 2
convert lookup column from access to sql server express 8
using a query for a lookup column 1
3 Combo Box Filtering of 1 table. 1

Top