We have a secure front-end access forms which get their data from SQL database. We needed to have a form open from an excel sheet. I got the code done which opens the right form with the correct ID from the Excel sheet, but when we use the combobox in that form to go to another ID, the form does not go to that data. We need to close out the form and then reopen it in order to get the combobox to work. The combobox is the tool users use to navigate through the different data. Is there a way to allow the combobox to work as it should without having to close and reopen the form?
Just saw that the Form Filter value is set with the value from the Excel VBA value. I see I need to get this filter set back to empty so the combobox will function as it should.
Last edited by mejohnm; 01-10-12 at 05:35.
Reason: more info