Add/Edit

[Guest]

I have a pulldown box that is link to a table for the list of selections.
Next to the box is an Add/Edit button that launches into the list table. When
I make changes to the table, the pulldown does not show the update until I
exit and relaunch the program.

Any suggestions are appreciated.

 

[Stefan Hoffmann]

hi,

I have a pulldown box that is link to a table for the list of selections.
Next to the box is an Add/Edit button that launches into the list table. When
I make changes to the table, the pulldown does not show the update until I
exit and relaunch the program.

Add a

cboPulldownBox.Requery

in the event code of the Add/Edt button.


mfG
--> stefan <--

 

[Guest]

Currently I have a macro in the onclick event that opens the form and does a
requery. The add/edit launches the separate form. After saving, I need the
combo box in the original form to update with the new information.

It seems that on the save of the add/edit form, a requery is required but
I'm not sure where.

Any other suggestions?

 

[Stefan Hoffmann]

hi,

A long overdue thanks. It worked like a charm.

Thanks.

mfG
--> stefan <--