Default date property from query to form 1

[thames11]

Hi,

I have a form with two text boxes to enter a from and to date range. I would like the default value of the from text box to be the lowest date within the database and the default value of the to text box the highest date in the database. I can get the lowest and highest dates from a query but am unable to show within the form textboxes as default values. How can this be achieved, please?

Best regards,

Simon

 

[TheAceMan1]

how are ya thames11 . . .

In VBE help have a look at the [blue]DMax[/blue] & [blue]DMin[/blue] aggregate functions! . . .

See Ya! . . . . . .

 

[thames11]

Thanks AceMan