On a particular form, I use a listbox to display records from several other, related tables. (A record in the main table may have n records in the relational tables.) By double-clicking on an item in the listbox, or clicking an Add or Edit button, the appropriate, related form is loaded, allowing for changes to the existing data or the addition of new records.

What is the best way to update the contents of the listbox on the main table form? I considered the CREATE event at startup, but it would be nice to have the listbox updated immediately after a new record is entered or after an existing record is edited as well as at startup. Any suggestions? Thanks.

View this thread on the forum...