get visual basic to tick a checkbox in access

[saddas]

hello

i have a form and a database linked by SQL.
i have checkboxes in the access database that are ticked when a product is sold
is there a way to make a checkbox in access tick once the product has been selected in the form?

thanks, help would be appreciated

[saddas]

would the code be something like
if textbox1.text = true then
.fields("available?") = true
end if

doesnt work but something along the lines of this?

[Jx_Man]

what type of your field?

[reygcalantaol]

Insert into table_name (boolean_field) values (true);

where
table_name is the name of your table
boolean_field is the name of the field with boolean type
true/false are the possible values to be inserted in boolean type field.

[saddas]

dont worry i solved it myself. thanks for the reply's though.

[reygcalantaol]

That's great you solved it by yourself.