Combo Box Requery Not Working w/On Current

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top