surely a form with a ListBox can be used in a query?
Tina, yes that helps. Now I actually get something that looks a lot
like a form pop up when I run the query so something is working better.
Unfortunaltely, the form has nothing at all on it -- it's blank. It
looks nothing like the design view of the form. I'm closer and will
keep trying.
Thanks a lot, Rob
tina wrote:
when Duane said "substitute", he meant substitute completely, as
Forms!frm_G!Genotype!
hth
"1.156" wrote in message
...
Duane, thanks a lot for trying to help.
My form is named "frm_G" and the NAME propertyof the listbox is
"Genotype". So, in the query criterion under the Genome field I typed
Forms!frmfrm_G!lboGenotype!
I have the form open and then I run the query. All I get is a box
labeled "Enter parameter value" with a single window above which is
Forms!frmfrm_G!lboGenotype!
Of course I want it to display the form with the listbox so I can select
Genotype.
Can you tell where I've gone wrong?
Thanks again, Rob
Duane Hookom wrote:
You would set the criteria of the "Genotype" field to:
Forms!frmMyForm!lboGenotype
Substitute your form and control name and make sure the form is open when
you run the report/query.
|