Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thr33xx
Starting Member
6 Posts |
 Posted - 2011-08-05 : 19:49:34
|
Hello all,I have a form in Access which is adding (inserting) records to a single table. In addition, on this same form, I have an Archive Checkbox, which when checked or unchecked, updates a second table (the study setup table).I am working in visual basic, and trying to add the action of when the "add record" button is pressed, the archive study checkbox is updated in the second table. Below is the sql code I have written, but I cannot seem to get it to work in Access. UPDATE dbo_setup SET dbo_setup.archive_study = '" & Me.Add_Archive_Study & "' WHERE study_id=’” & Me.Add_Archive_Study & “’” Any help would be greatly appreciated, as I'm still learning!Thank you |
|
|
thr33xx
Starting Member
6 Posts |
Posted - 2011-08-08 : 13:49:27
|
| Anyone? |
 |
|
|
|
|
|
Update Checkbox in Access form connected to SQL