MTB,

Thanks for getting back to me. Let me provide a little more detail. The field [EmployeeName] has its Is Hyperlink property set to Yes, and the above code is triggered on its On Click event procedure. The event opens a new form for that employee with a budget date within the range of the dates selected in txtstartdate and txtenddate in the original form's filter. The code produces a Run-Time Error '13': Type Mismatch.
...

Hi,

I have a filtered form that produces a set of employee names that are hyperlinks. When clicked, the EmployeeName hyperlink opens another form called Budgeted Time. I would like to filter the results of Budgeted Time to match the employee name and corresponding date range produced from the filters on the first form. The date fields are called txtstartdate and txtenddate. Many thanks for looking

...

Hi,

I've developed a form filter that produces a number of hours budgeted by employee/location/practice group/experience level and date available using some Allen Browne code. I have two command buttons, cmdFilter and cmdFilterAvail. cmdFilter filters the form based on the criteria selected via my list and text box filters. One of the fields in the form, text51 has a control source:=IIf([clientname]="Unassigned Time",[BudgetedHours],Null)...

I'm having difficulty filtering a form using a multiselect list box when using some Allen Browne code. I get the error "Syntax Error (missing operator)in query expression '([City] IN (""Sydney"Londo n)'. - when I filter the cities Sydney and London from the multiselect list box in the form. The list box multiselect is set to Simple. The code breaks at Me.Filter = strWhere four lines from the end. Thanks for looking!
...