Requery Combo on Subform (1 Viewer)

S

sparklegrrl

Registered User.
Local time
Today, 08:02
Joined
Jul 10, 2003
Messages
124
Hi all!

I have a form with 2 combo boxes for zip codes. I have it so that when you add a new zip it updates the table and re-queries both boxes.

The problem I have is that I have a sub-form with a zip code combo box on it that also needs to be re-queried on update.

I'm having trouble finding the right code and where to put it.

Any help is greatly appreciated.
 
Ranman256

Ranman256

Well-known member
Local time
Today, 03:02
Joined
Apr 9, 2015
Messages
4,339
forms!masterform!subform!form!cboBox.requery

use the BUILDER, it will get it correct.
 
S

sparklegrrl

Registered User.
Local time
Today, 08:02
Joined
Jul 10, 2003
Messages
124
Ranman256 said:
forms!masterform!subform!form!cboBox.requery

use the BUILDER, it will get it correct.
Click to expand...

Still giving me problems...I'm about to throw this machine. LOL

 
MajP

MajP

You've got your good things, and you've got mine.
Local time
Today, 03:02
Joined
May 21, 2018
Messages
8,516
Code: 
forms!masterform!subform!form!cboBox.requery

there is a mistake there. Controls and forms are items in a collection. "Form" is a property of the subform container. Need a period.

Code: 
forms!masterform!subform.form!cboBox.requery
 
MajP

MajP

You've got your good things, and you've got mine.
Local time
Today, 03:02
Joined
May 21, 2018
Messages
8,516
Also in the above, "subform" is the actual name of the subform control not the thing inside the control. Often the same sometimes something like child1.
 
MajP

MajP

You've got your good things, and you've got mine.
Local time
Today, 03:02
Joined
May 21, 2018
Messages
8,516
Also one simple trick. You can just requery every time you enter the combo. So instead of telling it to requery, just put in the combo's on enter event to requery. Depending on how much data and how often you do this, it could be an expensive choice. If this is hundreds to thousands of zips no problem 10-100s of thousands it will be slow.
 
S

sparklegrrl

Registered User.
Local time
Today, 08:02
Joined
Jul 10, 2003
Messages
124
MajP said:
Also in the above, "subform" is the actual name of the subform control not the thing inside the control. Often the same sometimes something like child1.
Click to expand...

Subform control? You mean the combo box?

I'm actually having this issue in 2 places.

a) I need to requery/update a combo in a subform after adding data to the one on the main form (zip code) and

b) I need a cascading combo box that uses the combo box on the main form to populate the 2nd one on the subform (customer/parts)
 
MajP

MajP

You've got your good things, and you've got mine.
Local time
Today, 03:02
Joined
May 21, 2018
Messages
8,516
Subform control? You mean the combo box?
Click to expand...
No, I mean the subformControl.
I have is that I have a sub-form with a zip code combo box on it that also needs to be re-queried on update.
Click to expand...

We interpreted this to mean you want to requery a combobox on a subform being called from the main form after you update the rowsource on the main form.

If that is the case, then in the main form you would call it like follows

Me!NameOfSubformControl.Form!NameOfComboOnSubForm.requery

There are two different things the subform control and the thing inside the subform. Usually they have the same name by default.

For the cascade you have to requery every time. So put the code in the combobox on enter event. That is the easiest. When you go into the subform and enter the control it then requeries itself. That is easier than calling from the main. However to now reference a combobox on the main form from code in the subform you need to use Parent.
from the sub.
me.Parent.NameofControlOnMainForm
 
S

sparklegrrl

Registered User.
Local time
Today, 08:02
Joined
Jul 10, 2003
Messages
124
MajP said:
No, I mean the subformControl.


We interpreted this to mean you want to requery a combobox on a subform being called from the main form after you update the rowsource on the main form.

If that is the case, then in the main form you would call it like follows

Me!NameOfSubformControl.Form!NameOfComboOnSubForm.requery

There are two different things the subform control and the thing inside the subform. Usually they have the same name by default.

For the cascade you have to requery every time. So put the code in the combobox on enter event. That is the easiest. When you go into the subform and enter the control it then requeries itself. That is easier than calling from the main. However to now reference a combobox on the main form from code in the subform you need to use Parent.
from the sub.
me.Parent.NameofControlOnMainForm
Click to expand...

Thank you so much! I will keep playing and see what I can do! Have a great day!
 
MajP

MajP

You've got your good things, and you've got mine.
Local time
Today, 03:02
Joined
May 21, 2018
Messages
8,516
If still having trouble you maybe can post a stripped down version of the db.
 
You must log in or register to reply here.

Similar threads

MattBaldry
Creating .zip file from Folder, then Deleting all other Files
Replies
1
Views
120
Gasman
Gasman
S
Solved Combo Box Issue Selecting Item versus Typing Item
Replies
14
Views
524
arnelgp
arnelgp
N
Solved Access query with linked tables slow
Replies
3
Views
402
Pat Hartman
P
D
Solved Synchronising a List Box to a Combo Box
Replies
9
Views
571
davegoodo
D
mike60smart
Requery Subform
Replies
8
Views
270
mike60smart
mike60smart

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom