I have a form which I want to show checkboxes that are checked according to the results from a query. If got the code under Form_load, this works that for the 1st record the box is checked, but goin to the other records there is no change.
I'd like the results not to be displayed by individual records, rather than on one screen/from show all the 4 or 5 records per ID, each checked in a checkbox.
All I've done is say:
if Materials ="metals" then
ChkMetals =True
End if
..for each option
Materials being the field of results from the query, ChkMetals being one of the checkboxes.
Any suggestions? Need a loop?
--As a side point, I'm going on to try and make it so that it you check a box, or take off the tick, this updates the main records, any ideas how I could go about doing this??
I'm really stuck, and have been trying this for days!
[This message has been edited by Elise_L (edited 07-25-2000).]
I'd like the results not to be displayed by individual records, rather than on one screen/from show all the 4 or 5 records per ID, each checked in a checkbox.
All I've done is say:
if Materials ="metals" then
ChkMetals =True
End if
..for each option
Materials being the field of results from the query, ChkMetals being one of the checkboxes.
Any suggestions? Need a loop?
--As a side point, I'm going on to try and make it so that it you check a box, or take off the tick, this updates the main records, any ideas how I could go about doing this??
I'm really stuck, and have been trying this for days!
[This message has been edited by Elise_L (edited 07-25-2000).]