ADP / Form with Buttons for Filtering

  • Thread starter Thread starter Michael Ervens
  • Start date Start date
M

Michael Ervens

Hi NG!

I created a Form with Komboboxes for easily filtering the data. I'm using a
stored procedure as RecordSource with the appropriate Parameters.

NOW I added a button to the Form. This button should set a filter that will
return the records with the current date!
I read the NG and tried around with ServerFilter and Filter but nothing
worked! Is it a problem wwith the StoredProcedure as RecordSource?!
Please help me!!

Thanx, Michael
 
Filters act on the Record set returned by the SP.
you need to write the code to send parms to the SP in the unclick event, of
the button
 
Hi BJ!

What do you mean with "SENDING" parms to the stored procedure?!

Thanx, Michael
 
If this stored procedure is the form record source, all you need to do is to
update the InputParameters value of the form with the appropriate info from
the combo boxes. Upon assigning the value to inputparameters in the code
the form automatically requeries.

HTH,
J. Clay
 
If your using a filter you also need to make sure the
Allow Filters property is set to true.

Chris
 
Back
Top