DLAST

[rhonda11]

When I updat a record from the subform by project ID. I would it to clone the last record with of the currect Project ID (not the last record in general of the table but depending on the last record for that project ID). I have tried to do the following, however it clone the last record of the table instead of the current Project ID.

This is what I have so far to clone a field (Deliver date)
in the Default Value:
Dlast("[DeliveryDate]", "ProjectUpdate", "[ProjectID]&quot

Can somebody tell me what's wrong w/ the above? I need help.

Thanks in advance

 

[PWise]

Dlast("[DeliveryDate]", "ProjectUpdate", "[ProjectID]=" & me.parent!projectid)
will return the last record with the same projectid as the parent form

 

[rhonda11]

I'm getting a "#Name?" error when executed. What I have is
Dlast("[DeliveryDate]", "ProjectUpdate", "[ProjectNo]=" & me.parent!projectNo).
After I saved it, went back and it was converted to the following:

=DLast("[DeliveryDate]","ProjectUpdate","[ProjectNo]=" & [me].[Project]![projectid])

It's still giving me #Name? on that field.

Any other idea?