VS 2005 checkbox with MS Access 2000 database

[godhulirbalaka]

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

[kenobewan]

Try using a dataadapter. Is the table id choosen by the user through entering a number in a textbox?

[godhulirbalaka]

Try using a dataadapter. Is the table id choosen by the user through entering a number in a textbox?

NO table ID is not a factor. I just want if i checked a checkbox in the form and save it then in database the linked filed which datatype is yes/no that will checked or unchecked accordingly

[kenobewan]

NO table ID is not a factor. I just want if i checked a checkbox in the form and save it then in database the linked filed which datatype is yes/no that will checked or unchecked accordingly

All you need is one event and two functions. What events are you planning to use? Apart from an insert statement what have you done so far?