ServerFiler Equivalent

[Marchello2004]

Hi there

I'm trying to use "ServerFilter" to be able to filter a form, but this is base on Access, not Access project, and I've been told ServerFilter will only work with Access project.

Is this true? and if so, what could I used instead?

Thank you very much!

Marcel Quiroga Defize

 

[fneily]

You also use serverfilter's with DAP's.
What exactly do you want to do? You're sort of vague. You mean something like select an item from a combobox and then the form displays that record? This has been done quite a bit. Do a search in the forms forum.

 

[Marchello2004]

Yeah, is just like you said, I'm filtering a subform by picking up the details from a combo box in another pop up form.

This is the code in the pop up form named frm_Filter_by_reference_type with a combo boxe called CmbStaff_number ...

Private Sub Done_button_Click()

On Error GoTo Err_OK_Click

If Me.OpenArgs = "Form" Then

Forms!Bookings_f.Bookings_subf.Form.ServerFilter = "((Bookings.staff_number like '" & CmbStaff_number & "'))"
DoCmd.close acForm, "frm_Filter_by_reference_type"
Forms!Bookings_f.Bookings_subf.Form.Refresh
Forms!Bookings_f.Bookings_subf.SetFocus

What I'm trying to filter is the subform (Bookings_subf) which is part of the main form (Bookings_f)
I thought the server filter does not work as the error message is "Application-deffined or object-deffined error"