parameter query problem ??

  • Thread starter Thread starter John James
  • Start date Start date
J

John James

I am trying to show a combo database box that is defined on a form but needs
to show when selecting a parameter value. I have tried to build the
expression using the expression builder but with no success. I am new to
access and its very frustrating. I keep getting the error message "query
must have at least one defined field"

I must have got the format wrong somewhere or it coukd be a usage problem/
any help apreciated. Can't I just call the combo from my query and if so
what is the proper sysnetax that is eluding me.
 
John

Queries don't have combo boxes, forms do. If you have a form with the combo
box, use a reference to that form's combo box in your query. Something
like:

Forms!YourFormName!YourComboBoxControlName

in the Criterion cell of the query design grid. This means you'll have to
start on the form, and add a command button that runs the query.

Remember that a combo box "holds" the bound column, which may not be the
same as the column it "displays".

Good luck

Jeff Boyce
<Access MVP>
 
Jeff:
I've been working on this issue for the last few days,
trying to figure out what's wrong. Your small comment to
John James starting out as "Remember that a combo box..."
was the lightbulb I needed. In two seconds I had my query
working!!! Thanks, Dan
 
Back
Top