Saving changes to an access table
Posted on 2007-10-12
I am trying to save changes made to a form using the following code.
The access database has a primary key so I know that is not the problem. However in my dataset designer I added something to the sql for the table to show only results where a checkbox is false. Not sure if this is causing the problem. Here is the SQL.
SELECT AutoNumber, [Check], [Date], [Time], BOLO FROM message where [check] = false