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)
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!