Query is forms recordsource

  • Thread starter Thread starter Jeff Klein
  • Start date Start date
J

Jeff Klein

How do I set the forms recordsource to a query in the forms on open event?
Form.RecordSource = qry_Union_Single_Weekly_Monthly does not work.
 
Herbert...Thanks for the help...but I have another question. My query
prompts for txb_startdate, If I set this code to the on Click a command
button it should take the value from the txb_StartDate instead of prompting
me right? Its not...why
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RecordSource Property 2
Parameter query prompts twice 2
How to Query on a forms custom recordsource? 7
Table Relationships with Queries / Recordsources 1
Allen Browne's Filter - Modification troubles 7
A2002: Subform's subform's RecordSource 6
Acc 2007 Subform Recordset vs Acc 2002 Subform Recordset 2
Query two subforms from 3 combo boxes 3

Back
Top