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 Re****t based on the Company that was
choosen
in the Combo Box.
The re****t 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 Re****t 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??
--
Message posted via http://www.accessmonster.com
