Update to table not showing

[funderburgh]

I have a data entry form with a list box bound to a database field. I have an additional control on the form that opens a new form to add data to the bound field. If the user's choice is not in the list, they can add it to the database. When data is added, it does not instantly appear in the list box. I can see that the data is in the database, but a user has to exit the entry screen and re-enter to see the update. Is there a command to refresh the cache, or another approach to get the newly input data available to the form? Thanks

 

[maxmangion]

Hi

Yes you have to "requery" in order to view your new added item in the list without closing and re-opening the form.

 

[funderburgh]

Thank you very much for the help. Is Requery a command or function - I can't find it in my referrence.

 

[maxmangion]

you should put Me.Requery in the after update event of your field on the form.

 

[funderburgh]

Thank you very much for the help.

John

 

[maxmangion]

You're welcome