Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query - Between [start date] and [ending date]

Status
Not open for further replies.

Dewey

Programmer
Jan 25, 2000
21
US
When I use the parameters in the QBE grid of 'Between [start date] and [ending date], I can pass to the reports these dates to print on the report, using the [start date] and [ending date] as the variables to print. When I try to pass these variables to a form, I get Name?. Somewhere I am missing a connection. I have tried setting a Public variable in the Code, but this does not work either. any ideas..thankx <p>Dewey Davis<br><a href=mailto:ddavis@dfn.com>ddavis@dfn.com</a><br><a href= > </a><br>
 
Can you paste in the code that passes and recieves the variables here?
 
Put the [start date] and [ending date] on the form then access these from the query as form!frmname!start and ..!end - this should do what you want.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top