Form Behavior/ListBox

[robrich22]

Ok, so I have a main form. On the form is a ListBox. When a user clicks an item in the listbox, it will open a "pop-up" form to edit the record in the listbox. When the user closes the "pop-up" form, I'd like the ListBox on the main form to reflect the changes made in the "pop-up" form.



How is this accomplished?

Thanks!

[ItsMe]

Restrict how the user closes the form that updated the table(s). Place some code that references the first form and requeries the listbox control. You will need to use the fully qualified name for the control

Forms!FirstFormName!ListboxControlName.requery
should do it.

Also, may want to add some code to save records in the first form before the other form opens and save records when the user closes the form. This is in an effort to avoid a warning messages that records have changed.