I would like to set a filter in a form (frmMainForm) from an access module. frmMainForm has a textbox control associated with a table field called "NAME_ONE" The below code will fail to find a record, even thought "120-595" is a valid value.
What am I doing wrong here? Thanks
Forms!frmMainForm.Filter = "NAME_ONE = '120-5965'"
Forms!frmMainForm.FilterOn = True