Problem updating Access record in Table

[glinch]

Hi there,

As the title suggests i'm having a wee bit of trouble updating a record in an Access 2007 database using the following macro in a workbook

I get the following message:

"Run time error -2147217913(80040e07)
"Data type mismatch in criteria expression"

Please Login or Register  to view this content.

Any help/advice would be greatly appreciated

Thanks

Noel

[davegugg]

What data type is propset in the table? It looks like you have a double for fieldVal, but you are putting single quotes around it in the SQL. I don't believe numbers need quotes. Same for recID.

If that doesn't work, which line is giving you the error?

[glinch]

Dave,

Great help, it was the quotes causing all the trouble.
I also had to remove the following:

Please Login or Register  to view this content.

at the end.

Thanks a million

Noel