A
Andy
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
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