Requery a previous Form

[Hiten]

Silly query, think I am missing something obvious but I shall ask anyway.\

I want to update certain lists in my form do the user can select from this list to update a field, so i click on a button and open a table, update a record and then close it to return to the form.

the List does not update unless I close the form and re-open it again.

Is there a property that automatically updates the list on exiting the query / table you are updating?

Thanks in advance

Hiten

 

[wazz]

try (?) Me.lstBoxName.Requery on the GotFocus event of the form. this could really use a lot of resources though if you lose and regain focus a lot.

consider a command button with Me.lstBoxName.Requery.

 

[Hiten]

Thank u so much

Fixed it. Thank u

have you seen my other post on the forms forum?