Hello! I am relatively new to vba but I am working on a database built by my predecessor and I need help with a form filter.
This form currently has a filter with the code:
I want to add another filter that looks at a serial number field and displays only serials that begin with 8 but I don't know to write this. I've tried variations of the following but keep getting errors:
Obviously, I don't know what I'm doing so any help would be appreciated!
This form currently has a filter with the code:
Code:
Forms![frmMenu]!sbfSubForm.Form.Filter = "endDate Is Null"
I want to add another filter that looks at a serial number field and displays only serials that begin with 8 but I don't know to write this. I've tried variations of the following but keep getting errors:
Code:
Forms![frmMenu]!sbfSubForm.Form.Filter Like "serialNumber = 8*"
Obviously, I don't know what I'm doing so any help would be appreciated!