Hi to all,
I have a main form with a subform with a Many-To-Many relationship.
I have a text Box on the main form. My subform has a combo box on it with Datasheet as Default View.
The user has to enter a text in the text box (txtSearch) on the main form so that the sub form will show only records for the search criteria only.
What code should I use in the AfterUpdate Event of the txtSearch text box to filter the subform.
Note: The data entered in the txtSearh might be part of the field.
Khalil