If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combo Box Requery Not Working w/On Current
Hi;
Have a main form, (frmCustomers), with a Tabbed Control that contains two sfrms, (sfrmCustomerAdditionalInfo and sfrmPurchasing). When the user clicks on the Tab=sfrmPurchasing an Unbound Combo Box, (its row source is Tbl/Qry), appears displaying a list of "Packaged Products". The Combo Box's Default Value is: "Click Here to Display Package List". When the user selects a package the underlying information populates the controls in sfrmPurchasing. All of this works correctly. What is not working correctly is when the user goes to a previous or new record on the main form. The Combo Box should display what was selected in a previous record and in a new record display the Default Value. It doesn't. In all records it displays what was selected previously. Meaning if while in record 6 the user selects "Package 1" all of the records show "Package 1". Have tried "Me!cboPackagedItems.Requery" in the On Current event of the frmCustomers and "Forms!frmCustomers.cboPackagedItems.Requery" in the On Current event of the sfrmPurchasing. Should I be using "Requery"? Where should the "Requery" be placed? Does the name of the Tab need to be Included? Is the statement "Forms!frmCustomers.cboPackagedItems.Requery" in the On Current event of the sfrmPurchasing correct? Would someone be so kind and point me in the right direction? Thank You for taking the time to read this post. Andy |
Thread Tools | |
Display Modes | |
|
|