Combo boxes...

[John W. Vinson]

I will add it back and see what happens. Does all the other stuff look normal?

Looks good to me, as best as I can tell from this remote vantage!

 

[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?

 

[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).

 

[thewabit via AccessMonster.com]

Thanks John,

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).

 

[thewabit via AccessMonster.com]

John,

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).

 

[thewabit via AccessMonster.com]

Nevermind...I got it working...I forgot to put the requery back in.

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).

 

[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?

Nevermind...I got it working...I forgot to put the requery back in.

Thanks John!

John,

[quoted text clipped - 5 lines]

 

[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?

Nevermind...I got it working...I forgot to put the requery back in.

[quoted text clipped - 5 lines]