A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Combo Box Requery Not Working w/On Current



 
 
Thread Tools Display Modes
  #1  
Old December 22nd, 2006, 02:09 PM posted to microsoft.public.access.forms
Andy
external usenet poster
 
Posts: 24
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:09 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.