Refresh a Combo Box (1 Viewer)

Brando

Enthusiastic Novice
Local time
Today, 02:01
Joined
Apr 4, 2006
Messages
100
Hello,

Thank you in advance for your help.

I have a Main form with a combo box that pulls names from a table. Alongside the combo box is a command button that opens a form which allows the user to edit the names in the table.

The problem: When a user edits a name and closes the edit form, the edit is not immediately displayed in the combo box. However, when the Main form is closed and reopened, the edit is properly displayed. Can I somehow refresh the combo box in the On Close event of the edit form?

Brando
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 02:01
Joined
Aug 30, 2003
Messages
36,139
Try

Forms!MainFormName.ComboName.Requery
 

Brando

Enthusiastic Novice
Local time
Today, 02:01
Joined
Apr 4, 2006
Messages
100
Simple perfection! Thank you!
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 02:01
Joined
Aug 30, 2003
Messages
36,139
Happy to help!
 

Users who are viewing this thread

Top Bottom