How to run a reqruey on form 1 after closing form 2

[Brent D]

This is my first post so lets see if someone can help me with my question. I have 2 froms. Form1 is used for data input in a customer call database and is linked to my main data table. On Form1 there is a Listbox that displays notes everytime we talk to the customer. I have a Button that calls Form2 where you enter the actual note. Form2 has a txtbox for the imput and a SAVE and CLOSE button. I'm good up to this point. Here is the question. When I click the save button it updates the NOTES table ok and it closes FROM2 but what I can't figure out is how to transfer control back to FORM1 and update FORM1 so the listbox containing the notes is updated and displays the new note with all the previously existing notes. I guess really what i need is help understanding what happens after a from is closed. What is next function ACCESS will perform??



Thanks in advance!

[Bob Fitz]

You could use some code in the On Close event of Form2 to requery the control on Form1 that shows the notes. Something like:
Forms!Form1Name.ControlName.Requery