Form control monitoring changes to table/query

[xcmav66]

Is there a way to make the data in a control refresh automatically if there is a change in the data in the table? I want a list box in my form to show data as I add records to a table or query. Is this possible? Right now it only works if I close and re-open the form.

 

[missinglinq]

Add the line Me.ListBoxName.Requery in your code, after adding the new record.

 

[xcmav66]

How would I do this if the list box is in one form and I am editing the table from another form? Thanks.