Can any give me some ideas?
I have two forms 'Vendors' and 'Vendor Info'
I have a combobox on the Vendors form that when doubleclicked opens the Vendor Info form and finds the vendor information based on the combobox selection. In the Vendor Info form you can add a new vendor.
Two problems are once the new vendor is added and I choose to save and exit, the Vendor Info form checks to see if the Vendor form is open then requeries the combobox. Then I can select it from the list, however all the information I see in the Vendor form is a different vendors information until I close the form and reopen it then when I select the newly added vendor I have the correct information. And the 2nd thing is when I save and exit after adding a new vendor I want it to select automatically go to that record on the main Vendor form. I appreciate everyone who can help.
Sincerely,
Chad
I have two forms 'Vendors' and 'Vendor Info'
I have a combobox on the Vendors form that when doubleclicked opens the Vendor Info form and finds the vendor information based on the combobox selection. In the Vendor Info form you can add a new vendor.
Two problems are once the new vendor is added and I choose to save and exit, the Vendor Info form checks to see if the Vendor form is open then requeries the combobox. Then I can select it from the list, however all the information I see in the Vendor form is a different vendors information until I close the form and reopen it then when I select the newly added vendor I have the correct information. And the 2nd thing is when I save and exit after adding a new vendor I want it to select automatically go to that record on the main Vendor form. I appreciate everyone who can help.
Sincerely,
Chad
