Parameters for Dates

[mike02]

Hey,



I have a date field and It list the dates in mm/dd/yyyy form. I have created a search from which displays the data in subforms in the Detail section. Search Criteria is in the form Header section. The search criteria includes start date, end date, and Name. The date will search on the name but ignores the search of star.end date. I have a calandar popup to select the date. Which then fills in the unbound text boxs with the date. I have tried the following parameters:

Between [Start Date:] AND [End Date:] Works but i have to manually insert it. The goal is to manipulate this expression to have the combo boxes insert the start and end dates in.

Tried this.

Between [Start Date:[Forms]![Search].[Form]![txtstart]] AND [End Date:[Forms]![Search].[Form]![txtend]]

That didnt work.

Does anyone have any ideas?

Thanks in advancE!

[pbaldy]

Try

Between [Forms]![Search]![txtstart] AND [Forms]![Search]![txtend]

[mike02]

Your a hero. THANKS! I have been trying for a while lol!!!!

[pbaldy]

No problem! Here's a good link on the syntax:

Forms Refer to Form and Subform properties and controls

[mike02]

thanks for the link. appreciate it!