Using Dlast Function on Page Load event

[moles]

I am having trouble with the syntax of Dlast. My page opens and I have a field named auto_number that I want to be populated with Auto Number from Table Daily Health Check. Currently I have:

Me.auto_number.Value = DLast("Auto Number", "OLP Daily Health Check&quot

What am I missing????I am receiving a runtime error 3075 syntax error (missing operator) in query expression.

I know that there is a criteria argument for Dlast but I am not sure how to use it...

HELP me.....

 

[FoxProProgrammer]

Hi moles,

Try this:

Me.auto_number.Value = DLast("[Auto Number]", "[OLP Daily Health Check]&quot

This should work if [Auto Number] is the name of a field in a table named [OLP Daily Health Check]. You need the brackets because the field and table name contain spaces.
dz
dzaccess@yahoo.com