DLookup Expression

[burrina]

I need to get the last check number from this table
table = TCheckNo
field = CCheckNo

I know this is wrong but what am I missing? Like DLookup

Code: Select all

Me.txtLicNo = DLast([CCheckNo],[TCheckNo],[CCheckNo])

[HansV]

The result of DLast is unpredictable. Moreover, the arguments of all functions such as DLookup must be strings.

If CCheckNo always increases, you can use

Me.txtLicNo = DMax("CCheckNo","TCheckNo")

[burrina]

Yes it is autoincremented.
Thank You Hans