Detailed instructions on creating a query

  • Thread starter Thread starter matthew
  • Start date Start date
M

matthew

I was instructed to use the following criterion in a
query: =Forms!frmname!cbofldname. I created this combo
box in an unbound form. I then entered it as a criterion
in an existing query in hopes of having the combo box show
up as one of the parameters and allow the user to choose
the parameter from the list. I'm sure i made an error
somewhere but if anyone could help i'd appreciate it.
thanks.
 
I was instructed to use the following criterion in a
query: =Forms!frmname!cbofldname. I created this combo
box in an unbound form. I then entered it as a criterion
in an existing query in hopes of having the combo box show
up as one of the parameters and allow the user to choose
the parameter from the list. I'm sure i made an error
somewhere but if anyone could help i'd appreciate it.
thanks.
Click to expand...

Let's say you have a Form whose Name property is "frmname", and on
that Form you have an unbound Combo Box with a Name property of
cbofldname. So long as frmname is open and a value has been selected
in fldname, a query with the criterion above will work. You may want
to put it in brackets:

=[Forms]![frmname]![cbofldname]

If the Form has a different name, or the combo box has a different
name, or the form isn't open, you'll get prompted.
 
Back
Top