How to commit data? 1

[ksbigfoot]

I have an Access 97 database and I have a form that is bound to a SQL Server table using an ODBC pointer.
My form has a save button on it in which I run the following code:
Me.dirty = false
On the click event of the Save button.
It is not committing the data to the SQL Server database.

Does anyone know why this is happening?

Thanks

 

[PHV]

And what about this ?
DoCmd.RunCommand acCmdSaveRecord

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ksbigfoot]

Howdy PHV,
That gave me an ODBC error message.
That points me in the right direction.
Thanks again and star to you.
ksbigfoot