Combo Box in Form does not recognice Combo Box in Sub Form

[Robert M]

I am wanting my sub form combo box to show the Cities based on the State Selected in my Form Combo Box. What I have in VBA code after update is...

strSQL = "Select " & Me!LkUpST
strSQL = strSQL & "FROM qryCity_Select"
'Forms!StateCityZipMilage_sfrm!LkUpCity.RowSourceType = "Table/Query"
Forms!StateCityZipMilage_sfrm!LkUpCity.RowSource = strSQL

When I run this I get a "Cannot Find the form 'StateCityZipMilage_sfrm' "

Thank you for your time and help in this matter.

Robert M

 

[pbaldy]

You're not referring to the subform correctly:

http://www.mvps.org/access/forms/frm0031.htm

 

[Robert M]

Heesshh!! Thanks pbaldy, good to hear from you again. I see where I am needing to have it set as...

Forms!StateCityZipMilage_frm!StateCityZipMilage_sfrm!LkUpCity.RowSource = strSQL

Makes sense as the computer don't know nuttin unless I tells it 8-P

Thanks for your help and answering so quickly.

Robert M

 

[pbaldy]

Happy to help Robert!

It would be nice if we could do the Vulcan Mind Meld or something to get the stupid computer to do what we intended. Sadly, they only do exactly what we tell them to do, which can be exceedingly frustrating.

 

[Robert M]

True, but I'm sure some mad scientist is working on just that problem. Till then, we can only control our desires to take a sledge hammer to the system.

 

[bestofthelousy]

pbaldy you are my hero! It seems like anytime I am stuck on something it is one of your responses that gets me to the solution. Thank you!

 

[pbaldy]

Excellent! Happy to help!