Hi everybody,
Can anybody suggest how to reference a table column name that has a space in VBA?
I'm working on a function to duplicate a selected record and copy the desired data into the new record. All fields work except the fields with spaces in their name.
For example, the Certificate Number field in table tblCertificates, contains a space. I'm not sure the syntax to reference this field name in VBA. I've tried every syntax I can think of. Any guidance would be appreciated.
Can anybody suggest how to reference a table column name that has a space in VBA?
I'm working on a function to duplicate a selected record and copy the desired data into the new record. All fields work except the fields with spaces in their name.
For example, the Certificate Number field in table tblCertificates, contains a space. I'm not sure the syntax to reference this field name in VBA. I've tried every syntax I can think of. Any guidance would be appreciated.
.AddNew
!Certificate Number = Me.txtCertificateNumber <------This line throws an error because of the space in the field name.
!Superceded = Me.chkSuperceded
!CertID = Me.cboCertID
!Issued = Me.txtIssued
!Market = Me.cboMarket
!Agency = Mecbo.Agency
.Update