Dlast

[rhonda11]

I have a form with a subform that gets update pretty often. Within this subform there's a delivery date field that I would like to remains the same everytime the user click to get a new form to update. What I did was put the following code on the Default value from the event. However, this code copy the last record in the table projectupate instead of getting tha last project update of a particular ProjectNo.

DLast("[DeliveryDate]","ProjectUpdate","[ProjectNo]&quot

I got the following code form PWISE:
Dlast("[DeliverDate}]","Projectupdate","[ProjectNo]="&me.parent!projectNo)

....but i got "#Name?" error

Can someone help.........pwise, where are you?

 

[psemianonymous]

DMax("[DeliverDate]","Projectupdate","[ProjectNo]=" & me.parent!projectNo)

fixed (hopefully)

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

 

[rhonda11]

Thank you for your help but it's still not working, i'm getting "#name?" error. What is this mean?