P
pheonix22
Guest
Hey all,
This is my first real database as part of a school project. I have 3 combo boxes linked up to a query. The whole query and text boxes work. However I need to find a way of clearing the combo boxes without a manual deletion of the criteria inside. I tried using the the code " Me![Comboboxname] = "" " but it crashes the system, even when i attach it to a command button. is this due to a loop being created? the search works perfectly without the code and using manual deletion. any ideas or suggestions would be appreciated.
Pheonix
This is my first real database as part of a school project. I have 3 combo boxes linked up to a query. The whole query and text boxes work. However I need to find a way of clearing the combo boxes without a manual deletion of the criteria inside. I tried using the the code " Me![Comboboxname] = "" " but it crashes the system, even when i attach it to a command button. is this due to a loop being created? the search works perfectly without the code and using manual deletion. any ideas or suggestions would be appreciated.
Pheonix