Saphirah
Active member
- Local time
- Today, 15:14
- Joined
- Apr 5, 2020
- Messages
- 163
Hello everyone,
i have a combobox in an access form. The rowsource is set to a table in my database.
Now whenever the user does a specific action i change the row source using VBA to display different values.
Whenever i close the form and reopen it again, the rowsource is set back to it's default value.
Now is there a possibility to "reset" the row source to it's default value using VBA without closing the form?
I know i can simply store the rowsource in a variable when opening the form, so this is more of a "good to know".
But there might be an easier solution!
Thanks for your help everyone
i have a combobox in an access form. The rowsource is set to a table in my database.
Now whenever the user does a specific action i change the row source using VBA to display different values.
Whenever i close the form and reopen it again, the rowsource is set back to it's default value.
Now is there a possibility to "reset" the row source to it's default value using VBA without closing the form?
I know i can simply store the rowsource in a variable when opening the form, so this is more of a "good to know".
But there might be an easier solution!
Thanks for your help everyone