hi Folks,

I haven't used access in a very long time, so i'm a little behind the 8 ball with it.

I've got a date selection form (frmWhatDates) with txt boxes txtStartDate and txtEndDate.
I want to send those values to report rptAccuracy
rptAccuracy pulls from query qry_report_totals_sorted (which just sorts a customized query qryReports) - qryReports looks for those two date fields.

I'm able to go from form -> qry_report_totals_sorted just fine - but when I try to go to form -> report the query prompts me for the dates.

Any ideas?

sigh - never mind.

i retyped it all, and it worked just fine .

went from form -> report - and set the query to look for the form.
Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.