This is also one of the unique features of VBA in Access. It is very easy (syntactially speaking) to access a field (column) of the record that a RecordSet is looking at through the window. For example, if we want to access the field called “Last Name”, we can use the following expression:
The exclamation point is used to designate the field name to access in a RecordSet. The square brackets are necessary in this case to surround a field name that has special characters (space, punctuations, etc.).