For some reason I seem to be having an issue with data not immediately refreshing on my form.

I have a form that pulls data from a table to populate a drop down on a form. I have a button on that form that allows users to add a entry to a related table. When adding and closing out of the table that opens, the entry is not refreshing in the dropdown unless I close out of the form and go back in. How can I set this up to immediately refresh?

Thanks!

are you having a user input directly into the table ??

I set up a button on the form which pops up the table and only allows them to add, they can't see any of the other data in the table.

What you are seeing is normal behaviour. There is no automatic requery of the list; you have to instigate it.

But using a table for the additions gives you no opportunity to do an automatic requery as a table doesn't have associated code. And you have to use code to force the requery.

If you use a form for your new entries instead then you can use the form_close event to run a command like..

Forms!mainformname!comboboxname.requery

Thanks for the help, I was able to get it to work now!