I am trying to set defaults for selected fields in a form based on the previous (last) record.
I can do this for a single field using the code below in Form Properties/BeforeInsert but I need to add three more fields. Is this possible and, if so, how should I phrase it and what separator should I use between each statement?
Private Sub Form_BeforeInsert(Cancel As Integer)
Room = DLast("Room", Me.RecordSource)