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

Report Driving Me Crazy!!

P: n/a
Hi to eveyone in the group, Can you please help with a problem I have.
I have a form with an unbound subform on it that I use just to display
data. This works fine. When I query the data it filters no problem IE:
Like "*" & [ Enter Album or Artist Name] & "*" This also works for the
report, But i dont want to query them both. I want to view filtered
data on the subform then press a button and have it view/print in the
report. I've tried recordsource = recordsource etc. but i'm getting
errors. Does this make sence?.

Nov 15 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Tue, 15 Nov 2005 13:29:12 +0000, Notation
<Da****@NO.SPAM.blueyonder.co.uk> wrote:

Yes.
My solution was to write the PK values of that filtered form to a
table, and have my report query inner join with it.

-Tom.

Hi to eveyone in the group, Can you please help with a problem I have.
I have a form with an unbound subform on it that I use just to display
data. This works fine. When I query the data it filters no problem IE:
Like "*" & [ Enter Album or Artist Name] & "*" This also works for the
report, But i dont want to query them both. I want to view filtered
data on the subform then press a button and have it view/print in the
report. I've tried recordsource = recordsource etc. but i'm getting
errors. Does this make sence?.


Nov 15 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.