Hi all,

while some things seem quite easy though complex, others seem difficult yet easy.......

would i be correct in assuming that if i had a query that pulled data to a form to show only items that had a tickbox value of false and i wanted make all of these true in one go, i would create an append query with the same information to make them all true? i guess this is correct however, i am not sure how to actually make the textbox set to a true value.

i think

Update QryMyAppendQry
Set TickBox = True

but where do i put this? is it in the Field box where you can build an expression? if this is a SQL statement, do i need an append query at all? could this be done purely with code alone?-

Sub MyAppendStatement()

Update QryMyAppendQry
Set TickBox = True


End Sub

i havent tried this yet but wanted to know for sure if i am correct or not and if not, how i would go about getting it right...


many thanks,


nigel

Not append qury, but UPDATE query.
Look at "DEmoQryTickBoxUpdA2000.mdb"
Look at table, query, run query, look at table.
I think it is what you need.
Before take a copy of your table.