JamiePMortimer
New member
- Local time
- Today, 05:16
- Joined
- Dec 2, 2016
- Messages
- 2
I'll caveat this with I have zero working knowledge of vba & minimal experience of access.
I have two criteria, I can get it working on the first, so it filters for employee number with a wildcard search and returning everything if the box is blank:
DoCmd.ApplyFilter "", "[Employee Num] Like ""*"" & [Forms]![Emp]![EmpBox] & ""*""
I want to create one if their start date is below a date in the unbound box [Forms]![Emp]![StartDateBox] and will return all employees if the [StartDateBox] is empty.
I have two criteria, I can get it working on the first, so it filters for employee number with a wildcard search and returning everything if the box is blank:
DoCmd.ApplyFilter "", "[Employee Num] Like ""*"" & [Forms]![Emp]![EmpBox] & ""*""
I want to create one if their start date is below a date in the unbound box [Forms]![Emp]![StartDateBox] and will return all employees if the [StartDateBox] is empty.