Updating combo list after table open from hyperlink edit
I have completed my database with the help of all you (YEAH - and thanks for all the help).
My issue is that i have several "Add" hyperlinks that open a table in datasheet view to update the combo list if new information is required. This worked fine when the database was in one piece.
However now that I split the database into a back-end/front-end server/client relationship i have encountered a small glitch. The ones installed before the split work fine, but the one I added to the form after the split doesn't work fully, it does still add the new selection to the back-end table but the selection is not available in the list after adding. You have to close/save the database first then on reopen it is available. I tried adding a "refresh" to the macro that opens the table but that did not work. Any suggestions would be very welcome.
I have completed my database with the help of all you (YEAH - and thanks for all the help).
My issue is that i have several "Add" hyperlinks that open a table in datasheet view to update the combo list if new information is required. This worked fine when the database was in one piece.
However now that I split the database into a back-end/front-end server/client relationship i have encountered a small glitch. The ones installed before the split work fine, but the one I added to the form after the split doesn't work fully, it does still add the new selection to the back-end table but the selection is not available in the list after adding. You have to close/save the database first then on reopen it is available. I tried adding a "refresh" to the macro that opens the table but that did not work. Any suggestions would be very welcome.
Last edited:
