VS 2005 checkbox with MS Access 2000 database

Question posted by: godhulirbalaka (Newbie) on July 3rd, 2008 12:04 PM

Dear sir,

I am making an application in visual studio 2005. In a form i have two checkbox and in access database i have two field which datatype is Yes/No. That means there is a checkbox shows it checked/unchecked

Now i want if i check in the checkbox in the form and save it then in the database field that field will checked or unchecked accordingly.

and when i will recall the data then according to the datafield the checkbox will checked or unchecked according to the database.

How do i set the command

Please give me both command one is INSERT/UPDATE command, Another is recalling command


my other command is like
str="INSERT INTO UserTable(ID, Transaction, Report) VALUES('" & me.txt_ID.text & "', '" & me.chk_transaction.checked & "',...................)

Please correct me

Not the answer you were looking for? Post your question . . .
189,891 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).