View Single Post
  #5  
Old May 31st, 2004, 08:41 PM
1.156
external usenet poster
 
Posts: n/a
Default 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.