List form sheet

  • Thread starter Thread starter Warrio
  • Start date Start date
W

Warrio

Hello!
In a sheet form where many reccords are displayed within one form, how can
we put a checkbox (not linked to any data) and when the user checks one of
these checkbox, only the one selected in the row is checked?
because if you click on one of them, all will have the same state!

Thanks!
 
You can't really do that.
An unbound control in any view will track the same for all 'instances'.
One way around this is to create a temp table Which has all the fields
needed for the form as well as a yes / no field for your check box. VBA code
will populate this table prior to opening the form. The form is based on
this temp table. When the operations on the form are finished you run an
update query to copy changed values to the desired tables or use the check
boxes to achieve some selection goal. You can when finished empty the temp
table.

--

peter walker MVP

Please post replies to the news group so everyone can benefit.
www.papwalker.com
 
Thanks a lot!


peter walker said:
You can't really do that.
An unbound control in any view will track the same for all 'instances'.
One way around this is to create a temp table Which has all the fields
needed for the form as well as a yes / no field for your check box. VBA code
will populate this table prior to opening the form. The form is based on
this temp table. When the operations on the form are finished you run an
update query to copy changed values to the desired tables or use the check
boxes to achieve some selection goal. You can when finished empty the temp
table.

--

peter walker MVP

Please post replies to the news group so everyone can benefit.
www.papwalker.com
Click to expand...
 
Back
Top