Update a combobox on another form

P

Patrick

This must be simple...

I have a main form(A) with a subform(B) containing a combobox linked to a
table.
On the main form(A) I open a form(C) containing the "combobox linked" table
After I add/change/delete data from this table and close the form(C) I want
to refresh the combobox on the subform(B).

On form(C) i have a close button with clicked event:

Forms![mainForm]![subform].Form![combobox].Refresh
DoCmd.Close

The Forms! line gives an error that this isn't supported.???

Any ideas?
 
P

Patrick

It was simple :)
Changed
Forms![mainForm]![subform].Form![combobox].Refresh
to
Forms![mainForm]![subform].Form![combobox].Requery
and it works fine.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need combo box to refresh when moving to new record 2017 1
Requery Subform ComboBox from Other Form 3
Lookup current record with ComboBox, any changes create new record 3
Update subform with combobox change on main form 1
combobox in form but not subform 1
Requery Fields with Combobox 3
Shared Sub-form referring to a field in the same sub-form 2
Is it possible to have If statements in a query? 2

Top