Textbox to display first date from table (1 Viewer)

[cocowomble]

Hi all,

fairly new to access and still learning a lot.
I need a textbox to display the first/earliest date from a table.

the table is called tblIncidents and the textbox is txtFirstDate

I've considered a variable and tried with querys etc.

any ideas, appreciate any help.

thanks in advance

 

[spikepl]

dlookup, dmax, dmin