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
Jump to Postwhat type of your field?
Jump to PostInsert 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.
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);
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.
dont worry i solved it myself. thanks for the reply's though.
That's great you solved it by yourself.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.