Requerying a subform control from a form

[Sam92Legacy]

I have a subform with a combo box for topics that describe the main form's record. When a topic needs to be added to the list, the user clicks on a button to bring up an "edit list" form. In order to refresh the combo box in the topic subform I've assigned this event for the edit list form's close button:

DoCmd.Close
Forms(Main).SetFocus
Me!Form(TopicSub).Topic.Requery

Where Main is the primary form, TopicSub is the subform, and Topic is the combo box. The edit form closes, the main form regains focus, but I get an error message saying that the command refers to an object that is either closed or doesn't exist. I've tripple-checked my spelling so I assume my grammar is wrong. Any suggestions?

Thanks,

Sam

 

[jaydeebe]

Try this - Form_Mainformname.subformname.controlname.Requery

check the subform name is set to what you get when you right click properties the subform while in design view on the main form.

Only dead fish (and shit) go with the flow!

 

[Sam92Legacy]

When I used that I got the error "Method or data member not found." with .Topic highlighted in blue and the Private Sub line in yellow. The subform name is the same as both a form and as an object in the main form. Could that be a problem?

 

[jaydeebe]

having the same name is no problem. It helps to avoid confusion.

What about this -

DoCmd.Requery Topic

 

[Sam92Legacy]

That worked perfectly. Thanks, Jay.

 

[jaydeebe]

Forms![Main]![Topicsub]![Topic].Requery also works for sure (access97), i tested this one!

Only dead fish (and shit) go with the flow!