Trouble Refreshing the Combo list in a subform

[StephenS]

For the last couple of days I have been trying in vain to get the list for a combo box to refresh. The idea shown in "Tips and Tricks" on this web site was one of the first techniques I tried. It suggests using the following code on the main form:

Me![Sub-form Name].Form![Control Name].Requery

Or, use the following in the subform:

Me![Control Name].Requery

Either way, I come up with the following Error message: "Object doesn't support this property or method."

Is there a reference I need for this? Requery seems to be supported for controls in the main form but not for controls in the subform. I have tried many other 'tricks' to try and fool it also, but this method would still be the best if I could get it to work.

Thanks for any info!

Stephen S.

 

[StephenS]

Found the problem. Hard to believe I worked so long on this one. I was mis-naming the field in my Requery statement. Obviously, naming it correctly made it work better.

Stephen S.