 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008Yes/No Box
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? 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.  SignatureKen Snell <MS ACCESS MVP> > My main form F_PurchaseOrder has a subform, F_PurchaseOrder Details. Each > line contains information for one practicular product that we will [quoted text clipped - 15 lines] > record in the subform, all records in the subform activate to the Yes > position. What am I doing wrong? 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? > You must bind the checkbox to a field in the subform's RecordSource query. > Your observation indicates that your checkbox is unbound -- meaning that [quoted text clipped - 20 lines] > > record in the subform, all records in the subform activate to the Yes > > position. What am I doing wrong? > 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? [quoted text clipped - 23 lines] > > > record in the subform, all records in the subform activate to the Yes > > > position. What am I doing wrong? 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? [quoted text clipped - 23 lines] > > > record in the subform, all records in the subform activate to the Yes > > > position. What am I doing wrong? Glad you found the solution. SignatureKen Snell <MS ACCESS MVP> > 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? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.