Date Entry Form (1 Viewer)

[davie303]

Hi can any one help
I need to create a date entry form using a begining date and an ending date.
I need to click a button after entering the dates to run a query using the criteria entered into the date form.
I have seen these date forms on many access database but cannot figure out how to do it.

Thanks

Davie

Glasgow
Scotland

 

[DJN]

Davie, you need two text boxes and a command button. e.g. txtStartDate, txtEndDate. in the criteria of date field for the query, place this:

Between [forms]![frmYourFormName]![txtStartDate] And [forms]![frmYourFormName]![txtEndDate]

Then just call the query from the command button.

David