Combo Box used to Filter a Query

[alhindson via AccessMonster.com]

I thought this was an easy one but I've been going rounds with it all day:

I have a button that opens a form "frmCompanyNameCritieria" and the form has
one combo box (unbound) with a row source of tblCompany (shows Company Names
that are available to choose from). I have a macro set up for After Update
(on the combo box) to open the Report based on the Company that was choosen
in the Combo Box.

The report is based on a Query and one of the fields in the query is Company
and in critieria I pointed to the Combo Box on my form (the text not the
label)

I thought this would be very simple and I didn't write any VB for it...but
when I choose a Company name from the Combo Box the Report opens up Blank.
But if I take out the criteria for the query the query will open with ALL
companies....so Im not sure why it won't take my "criteria" used in the
ComboBox...

Any thoughts??

 

[alhindson via AccessMonster.com]

NEVER MIND...GOT IT.

New it was something small on my end..guess I just had to type it out step by
step to find it!!

 

[Jeff Boyce]

Are you certain the combobox's bound column matches what is stored in the
table/query that feeds your report?

Any chance one of your tables is using a "lookup" data type?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[alhindson via AccessMonster.com]

Hi jeff-
Thanks for the response-the issue was with my bound column...figured it out
after I posted..

Thanks so much!!