Textbox displaying the Min()

[Lifeseeker]

Hi guys,

I have a blank form, and it has two textboxes which are meant to show

1) from date
2) thru date

in the control source of my first textbox, I put in....

=Min([TEST].[Dates])

but I'm getting ERROR in that textbox. Basically I want to just find the smallest date in the column "Dates".

The query "TEST" basically returns a list of dates, and the min() will obviously return the smallest of it, but it is currently not.

Can someone help me?

Thanks

 

[pbaldy]

Is the form bound to the query? If not, use DMin() to get the earliest date.

 

[Lifeseeker]

Is the form bound to the query? If not, use DMin() to get the earliest date.

I have actually changed the textbox into combobox, allowing users to select a particular date.

How would you write the code if you are using DMIN()?

The textbox is not bound to the form. (it says unbounded textbox).

How do I get it to bound to the form?

Thanks

 

[pbaldy]

=DMin("Dates", "Test")

 

[Lifeseeker]

=DMin("Dates", "Test")

Ah easy fix. Thank you!

 

[pbaldy]

Happy to help!