The below code works. However, when I move to another tab within the navigation form I get a message asking me to save the form. The filter within the form changes to whatever I entered in the [txtSearchBrandName] control and therefore prompts me to save.
Is there a way around this? I'm not so interested in saving the changes, but if I have to I would like to do so without a prompt to the user.
Forms![MainMenu].Form![NavigationSubform].Form![frm_PremierProductLaunchPlanner_SubFrm_FDB].Form.Filter = "[FDB_BrandName] Like '*" & Forms![MainMenu].Form![NavigationSubform].Form![frm_PremierProductLaunchPlanner_SubFrm_FDB]![txtSearchBrandName] & "*' "
Me.Form.FilterOn = True
Me![txtSearchBrandName] = ""