Continuous Form & OptionBox

[FrymanTCU]

Ok I guess my problem might be that the form is bound but it is a subform and it just seemed easier. I have a form with client data and then a subform with the related documents. I am trying to add an OptionBox next to their documents but when I select one it selects them all.

The subform is very simple, a Textbox and OptionBox. I tried to leave the form as unbound then setting the Recordsource with SQL but I only got one record to display. Any suggestions?

Thanks,
Rich:think:

[OBP]

Rich, Forms in Continuous Mode do not work with unbound fields or Controls, as you have found they all get the same value or selction.
So therefore to make your Option work you need a Fiedl in your table or query providing the Form's Control Source to hold the Option Selection.

[FrymanTCU]

So could I build the field in SQL and then update the records where that OptionBox was Selected? I am pulling the data from the Log and if they select the Option Box it creates a new record in the Log otherwise it remains the same...Hope that makes sense.