Unbound checkbox in subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Samantha - 23 Aug 2005 22:05 GMT

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.

Reply to this Message

RuralGuy - 23 Aug 2005 23:17 GMT

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
[quoted text clipped - 6 lines]
>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.

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

Reply to this Message