Search results

Here is what I changed it to rst_pc_table.Filter "person_id = " & Current_PersonID & "And client_id = " & Current_ClientID Now I get "Compile error: Invalid use of property" and the .Filter is highlighted.

Need help getting this correct. Need to filter ADO rst by 2 criteria. I know this is way off but to give you an idea. rst_pc_table.Filter "person_id = " & Current_PersonID And "client_id = " & Current_ClientID

that worked. thanks for the help

Thanks for the help but that didn't work. Recieved error number 2950 with the Arguments: -1, , First, ="[fac_id] = " & Str(Nz([Screen].[ActiveControl].[Column](0),0)) & " AND [referral_type] = " & [Me]![Combo2]

I have a form that has a Combo box record selector which works fine. I need to add more to the Where condition of this macro. Combo1 - Options 1-Facility, 2-Physician (referral_type) Combo2 - Record selector that works, either shows a list of facilities or list of physicians. Macro...