Filtering a forms recordsource being used for a report

[Gerry Abbott]

Hi all.
Im using a form's recordsource for a report. which works fine

Me.RecordSource =
Forms("frmdate01").Form.Controls("HoldLog").Form.C ontrols("frmHoldLog01").Form.RecordSource
Ive got a couple of buttons on the form which allows the user to filter from
a full recordset, on the form. I now wish to use a date filter when running
the report, so that the report takes the filtered recordset (me.recordset)
and applies the date filter. I don't mind if i have to put a form in the
middle to hold the dates, but i do need to apply the date filter only the
the form's current recordset.

Any ideas?

--

[Gerry Abbott]

Bump,
Any ideas?

Thanks in advance.
"Gerry Abbott" <pl****@ask.ie> wrote in message
news:oN**************@news.indigo.ie...

Hi all.
Im using a form's recordsource for a report. which works fine

Me.RecordSource =
Forms("frmdate01").Form.Controls("HoldLog").Form.C ontrols("frmHoldLog01").Form.RecordSource
Ive got a couple of buttons on the form which allows the user to filter
from a full recordset, on the form. I now wish to use a date filter when
running the report, so that the report takes the filtered recordset
(me.recordset) and applies the date filter. I don't mind if i have to put
a form in the middle to hold the dates, but i do need to apply the date
filter only the the form's current recordset.

Any ideas?

--

[Gerry Abbott]

Well No reply from the group on this one....?

The solution i used was to apply all the filters from the form, and use it
to modify the SQL, which I used as the new recordsource. The report was then
run from the Form recordsource.
Gerry Abbott
"Gerry Abbott" <pl****@ask.ie> wrote in message
news:oN**************@news.indigo.ie...

Hi all.
Im using a form's recordsource for a report. which works fine

Me.RecordSource =
Forms("frmdate01").Form.Controls("HoldLog").Form.C ontrols("frmHoldLog01").Form.RecordSource
Ive got a couple of buttons on the form which allows the user to filter
from a full recordset, on the form. I now wish to use a date filter when
running the report, so that the report takes the filtered recordset
(me.recordset) and applies the date filter. I don't mind if i have to put
a form in the middle to hold the dates, but i do need to apply the date
filter only the the form's current recordset.

Any ideas?

--