Query output to datasheet not the form

[Guest]

Hi All,
I've tried a couple of methods recommended here but I can't get the query
results to populate the form. It goes to a datasheet.

I'm using a combo box for the criteria and Afterupdate run the query. The
datasheet output displays the correct data. I even tried the wizard to create
a form based on a query, changed the text box to combo box and I still get
the datasheet output. My form is unbound.

Please help.
Thanks
Bill
Thanks

 

[John Vinson]

Hi All,
I've tried a couple of methods recommended here but I can't get the query
results to populate the form. It goes to a datasheet.

I'm using a combo box for the criteria and Afterupdate run the query. The
datasheet output displays the correct data. I even tried the wizard to create
a form based on a query, changed the text box to combo box and I still get
the datasheet output. My form is unbound.

Please help.
Thanks
Bill
Thanks

Don't "run" the query AT ALL.

Instead, use the Query as the Recordsource property of a form; open
that form using a command button or in the AfterUpdate event of your
criteria form.

John W. Vinson[MVP]

 

[Guest]

Thanks John - I'll try again, tried something similar and didn't the results
I was looking for.