Setvalue of control to same as last record

[MikiH]

Hi

I've got a combo box on a subform which selects a "build activity" from a list (limited to list).

What I want to happen is that after I've entered the first record on the subform the next record defaults to the selected "build activity" selected in the first record.

Thanks
Mick

 

[Lightning]

Try using the DLAST function. You can look this up in the Access On-line Help topic
DFirst, DLast Functions

HTH
Lightning