One of the forms in the application that I am working on contains a LISTBOX that is used to display related records. One record on this form may have n related records from different tables. As additions and modifications are made to the related tables, what is the best way to update the contents of the Listbox? My first thought was to place a script in or call a stored procedure from the CREATE event of the form that would populate the listbox. It would be nice to 'refresh' the contents of the listbox immedately after new or changed records from the related tables are saved. Any suggestions for a good way to handle this? Thanks.

View this thread on the forum...