By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,480 Members | 1,214 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,480 IT Pros & Developers. It's quick & easy.

Filtering a forms recordsource being used for a report

P: n/a
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?

--

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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?

--

Nov 13 '05 #2

P: n/a
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?

--

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.