Run-time error "2447": There is an ...

[Asif]

Hi, on my db when I click a command button to open a form i get the
error message

Run-time error '2447": There is an invalid use of the .(dot) or !
operator or invalid parentheses.

When I click debug it highlights the following line of my coding

strSQL = "UPDATE tbl_DateUpdate SET StartDate = '" & Me.txt_StartDate
& "'"

Just to give you a background I have a form the holds the date
(txt_StartDate) and when the user clicks on this command button the
date (txt_StartDate) is stored in a table (tbl_DateUpdate)

txt_StartDate is unbound field and StartDate is a text field

Any ideas on how to reslove this problem?

Thanks

 

[Asif]

Hi, on my db when I click a command button to open a form i get the
error message

Run-time error '2447": There is an invalid use of the .(dot) or !
operator or invalid parentheses.

When I click debug it highlights the following line of my coding

strSQL = "UPDATE tbl_DateUpdate SET StartDate = '" & Me.txt_StartDate
& "'"

Just to give you a background I have a form the holds the date
(txt_StartDate) and when the user clicks on this command button the
date (txt_StartDate) is stored in a table (tbl_DateUpdate)

txt_StartDate is unbound field and StartDate is a text field

Any ideas on how to reslove this problem?

Thanks

I've just noticed that if i close the form and re-open it and then try
click on the command button then I don't get the above mentioned error
message