Unbound checkbox in subform

S

Samantha

I have a union query that shows data from 2 tables. The data is shown in a
sub-form in datasheet view, based on selection from a combo-box from the main
form. I have 2 problems.
First, the user need to mark the records as processed in the subform. I know
that because it's a union query, the recordset in the subform is not
updateable. I added a check box in the sub-form, but when it's checked, all
of the records are checked. I need a way to check the records individually.

Second, if the first problem is solvable, is there a way to identify all the
records that are checked in the subform? thanks so much.
 
R

RuralGuy

Sorry Samantha,

You are between a rock and a hard place right now. The only way a
checkbox in a continuous SubForm can be unique is to be bound to a
field in the underlying query. To do what you desire requires the
query to be updateable.

I have a union query that shows data from 2 tables. The data is shown in a
sub-form in datasheet view, based on selection from a combo-box from the main
form. I have 2 problems.
First, the user need to mark the records as processed in the subform. I know
that because it's a union query, the recordset in the subform is not
updateable. I added a check box in the sub-form, but when it's checked, all
of the records are checked. I need a way to check the records individually.

Second, if the first problem is solvable, is there a way to identify all the
records that are checked in the subform? thanks so much.
Click to expand...

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
Top