Run a query with a parameter based on a subform textbox

[RayMilhon]

I'm using MS Access 2010 and I'm having an issue with a Report. The Query for the Report includes 2 Parameters that are based on unbound textboxes on the Reports Page of my Database. I'm using the Navigation Control so the syntax is Between [Forms]![mainmenu]![NavigationSubform].[Form]![txtstart] And [Forms]![mainmenu]![NavigationSubform].[Form]![txtEnd]

But for some reason Even though I've verified I put in dates in those two fields they are coming back blank. I tried creating global variables called dtstart and dtend and then in the after updated event for each text box setting those two variables = to the start date and end date but the query still prompts me for dtstart and dtend. I know I've done this before but apparently I've forgotten a step and no idea where to proceed to get the date range into my query. Help!!!!!!!!!!!!!!!!!!!!!

[pbaldy]

The form controls should work, presuming that's the correct spelling and syntax (I haven't used a Navigation form). The global variables won't work, they aren't known outside VBA. The workaround to that is creating a public function that returns the value of the variable, and using that in the query.

[pbaldy]

Oh, and make sure you've hit tab or enter after entering a date in the form textbox, or it's value won't be seen by the query. Mistake I've made a number of times while testing.