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

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?

what type of your field?

Insert into table_name (boolean_field) values (true);

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.

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

That's great you solved it by yourself.