J
John W. Vinson
Looks good to me, as best as I can tell from this remote vantage!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Looks good to me, as best as I can tell from this remote vantage!
T
thewabit via AccessMonster.com
I have discovered that these combo boxes are on a subform. Do I have to list
the main form AND subform somewhere in the filter?
the main form AND subform somewhere in the filter?
J
John W. Vinson
I have discovered that these combo boxes are on a subform. Do I have to list
the main form AND subform somewhere in the filter?
Yes, in the syntax
=[Forms]![mainformname]![subform].Form![controlname]
where [subform] is the name of the Subform Control on the main form (which
might be different from the Name property of the Form object within that
control).
T
thewabit via AccessMonster.com
Thanks John,
I will give it a try
I will give it a try
I have discovered that these combo boxes are on a subform. Do I have to list
the main form AND subform somewhere in the filter?
Yes, in the syntax
=[Forms]![mainformname]![subform].Form![controlname]
where [subform] is the name of the Subform Control on the main form (which
might be different from the Name property of the Form object within that
control).
T
thewabit via AccessMonster.com
John,
Would I find the subform control in the properties of the main form?
Would I find the subform control in the properties of the main form?
I have discovered that these combo boxes are on a subform. Do I have to list
the main form AND subform somewhere in the filter?
Yes, in the syntax
=[Forms]![mainformname]![subform].Form![controlname]
where [subform] is the name of the Subform Control on the main form (which
might be different from the Name property of the Form object within that
control).
T
thewabit via AccessMonster.com
Nevermind...I got it working...I forgot to put the requery back in.
Thanks John!
Thanks John!
John,
Would I find the subform control in the properties of the main form?
[quoted text clipped - 6 lines]might be different from the Name property of the Form object within that
control).
T
thewabit via AccessMonster.com
Getting closer but new problem.
The 2nd combo box which displays records based on the selection of the first,
only displays records for first 9 selections in the top box. When 10-42 is
selected in the first box, no records will show in the second box. Is this a
properties setting?
The 2nd combo box which displays records based on the selection of the first,
only displays records for first 9 selections in the top box. When 10-42 is
selected in the first box, no records will show in the second box. Is this a
properties setting?
Nevermind...I got it working...I forgot to put the requery back in.
Thanks John!
[quoted text clipped - 5 lines]John,
T
thewabit via AccessMonster.com
I solved my problem...disregard.
Getting closer but new problem.
The 2nd combo box which displays records based on the selection of the first,
only displays records for first 9 selections in the top box. When 10-42 is
selected in the first box, no records will show in the second box. Is this a
properties setting?
[quoted text clipped - 5 lines]Nevermind...I got it working...I forgot to put the requery back in.