linking queries to unbound lookup on a form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DK - 30 Jul 2007 13:50 GMT

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.

Reply to this Message

Ofer Cohen - 30 Jul 2007 13:56 GMT

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

Signature

Good Luck
BS"D

> 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.
[quoted text clipped - 10 lines]
>
> Here is SQL of the query and all fields are correctly named.

Reply to this Message

Klatuu - 30 Jul 2007 14:44 GMT

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.

Signature

Dave Hargis, Microsoft Access MVP

Reply to this Message