List form sheet

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!
 
P

peter walker

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
 
W

Warrio

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top