Yes/No Box

[Nancy]

My main form F_PurchaseOrder has a subform, F_PurchaseOrder Details. Each
line contains information for one practicular product that we will purchase.
I want to put a Yes/No check box under “Return Information†that identifies
if a return is due. When the check mark is activated in the yes mode, I want
a second form, F_ReturnInfomation, to open up. I want the select information
from the F_PurchaseOrder and F-Details to autopopulate the
F_ReturnInformation.

Once I get this procedure down, I will use the exact some procedure to track
warranty issues.

I have the yes/no check box on my subform. When I click the box for one
record in the subform, all records in the subform activate to the Yes
position. What am I doing wrong?

 

[Ken Snell \(MVP\)]

You must bind the checkbox to a field in the subform's RecordSource query.
Your observation indicates that your checkbox is unbound -- meaning that
whatever you do in one record for that checkbox will appear in all the
records for that checkbox.

 

[Nancy]

So how do I fix it. I have a field with named return with a Yes/No checkbox
in the table and the recordsource query for the subform. What am I missing?

 

[Nancy]

Never Mind. I figured it out.

So how do I fix it. I have a field with named return with a Yes/No checkbox
in the table and the recordsource query for the subform. What am I missing?

 

[Nancy]

So how do I fix it. I have a field with named return with a Yes/No checkbox
in the table and the recordsource query for the subform. What am I missing?

 

[Ken Snell \(MVP\)]

Glad you found the solution.