New record not immediately available to other forms

[mcahal]

I have an equipment database with a "main menu" page. There is a button to add vendor. When this button is activated and vendor name is inserted/saved/closed, the newly created vendor isn't immediately available in another form. I have to close out of the database and open it back up before it's visible. What can I do to make the new record immediately available to other forms?

[ranman256]

no, you only have to refresh the screen.
the underlying query on the form needs refreshed. put a button on whatever form
on click()
me.requery

[IrogSinta]

I'm assuming this other form is already open, that's why it's not immediately available. If you close and open that other form, do you see the new vendor? If that's the case, then the code that you need to add to the Add Vendor button is the following:

Forms!NameOfOtherForm.Requery

Now if instead it's not available on a control (i.e. combo box, list box) on the other form, then you need to require that particular control. So your code instead would be the following:

Forms!NameOfOtherForm!NameOfControl.Requery

Ron

[mcahal]

Thanks both so much! I'm going to try both.

[mcahal]

I ended up just adding the requery command to my "save and close" button. Thank you again!!