exrpression format ?

[eillyrayd]

hi

having a problem with expression not found i am running the following code behind a click

Private Sub btnCopy_Click()
Dim dbs As DAO.Database, Rst As DAO.Recordset
Dim F As Form

' Return Database variable pointing to current database.
Set dbs = CurrentDb
Set Rst = Me.RecordsetClone

On Error GoTo Err_btnCopy_Click

' Tag property to be used later by the append query.
Me.Tag = Me![Quote Nob]

' Add new record to end of Recordset object.
With Rst
.AddNew
!Customer_Number = Me!Customer_Number

but i get an error saying customer_number cannot be found

the actual field name is customer number with no _

do i need to change the formatting

thanks

 

[Rich]

Remove the space between Customer and Number
such as CustomerNumber
or surround the field with brackets
[Customer Number]