What am I doing wrong???

Egg 'n' Bacon · Post by **Egg 'n' Bacon** » 20 Oct 2010, 07:51

Really simple thing; putting in a query criteria based on a combo box in a form (e.g. like [forms]![frmEtc]![cboSelect]). But the criteria is not getting picked up & the query is coming up blank.

Any ideas (see attached)

TIA

E&B

ElecTest.zip

Post by **HansV** » 20 Oct 2010, 08:01

The bound column of the combo box corresponds to the numeric ID field of tblEquip, not to the Type field.
Set the Row Source of the combo box to

SELECT DISTINCT tblEquip.Type FROM tblEquip

Set Column Count to 1 and clear the Column Widths property.

Egg 'n' Bacon · Post by **Egg 'n' Bacon** » 20 Oct 2010, 08:35

OK I can see the problem, but the query is still coming up blank when any criteria is selected :(

PS I'm using 2003 format from a 2007 install.

Egg 'n' Bacon · Post by **Egg 'n' Bacon** » 20 Oct 2010, 09:01

Never mind, had made a typo

Post by **HansV** » 20 Oct 2010, 09:08

See the attached version.

ElecTest.zip

Egg 'n' Bacon · Post by **Egg 'n' Bacon** » 20 Oct 2010, 09:26

Thank you Hans

Post by **HansV** » 20 Oct 2010, 09:37

I had missed your previous reply, sorry.

Eileen's Lounge

What am I doing wrong???

What am I doing wrong???

Re: What am I doing wrong???

Re: What am I doing wrong???

Re: What am I doing wrong???

Re: What am I doing wrong???

Re: What am I doing wrong???

Re: What am I doing wrong???