0

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

3
Contributors
5
Replies
6
Views
6 Years
Discussion Span
Last Post by reyborn
0

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?

0

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.

0

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.