I have a main form (Form A) displaying a combo box , a command button (Find), and a subform control. When a user selects one value selected from the combo box, the subform will be populated with associated values from one of two queries. This works fine.
Also, on the main form is a command button for clearing all fields on both the main form and subform. The problem is that if all fields are cleared on both forms and then the user selects another value from the combo box to search for using the Find button, an MS Assess msgbox appears stating "You have canceled the previous operation". At this point no other search can be done until the form is closed and reopened again.
Any idea what may be happening here? It seems to be a form recordsource issue.
Also, on the main form is a command button for clearing all fields on both the main form and subform. The problem is that if all fields are cleared on both forms and then the user selects another value from the combo box to search for using the Find button, an MS Assess msgbox appears stating "You have canceled the previous operation". At this point no other search can be done until the form is closed and reopened again.
Any idea what may be happening here? It seems to be a form recordsource issue.
