ADP / Form with Buttons for Filtering

[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

 

[BJ Freeman]

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

 

[Michael Ervens]

Hi BJ!

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

Thanx, Michael

 

[J. Clay]

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

 

[Chris]

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

Chris