Query output to datasheet not the form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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]
 
Thanks John - I'll try again, tried something similar and didn't the results
I was looking for.
 
Back
Top