Find Max Date in a recordset 1

[plcman]

Hi

I have 2 tables 1)Gauges and 2) Calibrations, they are linked through the field G_No. I have a form that shows the fields in the Gauges table, I also need to display on the form the date of the last entry into the calibrations field for the current gauge (G_No).

Any help would be appreciated.

 

[TheAceMan1]

How are ya plcman . . .

Try this in the forms [blue]OnCurrent[/blue] event (double check all table/field names):

[blue]   Dim Cri As String
   
   Cri = "[G_No] = [red][b]'[/b][/red]" & Me!G_No & "[red][b]'[/b][/red]"
   Me!TextboxName = DMax("[LastEntryFieldName]", "Calibrations", Cri)[/blue]

If G_No is numeric, remove the two single quotes in [red]red[/red]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[plcman]

Hi TheAceman1

That works just fine, Thanks for your help!