This is what I have for opening a report based on the value of a combo
box.
If Me.cboIngredient.Value <> "" Then
strWhere = "[Ingredient]=" & "'" & Me![cboIngredient] & "'"
DoCmd.OpenReport "Recipe Details - Ingredients", acViewPreview,
strWhere
Dawn Crosier
Application Specialist
"Education Lasts a Lifetime"
This message was posted to a newsgroup. Please post replies and
questions to the group so that others can learn as well.
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf Of Garry
Sent: Friday, March 17, 2006 4:37 PM
To: [email protected]
Subject: [ms_access] Re: Report help
Thanks for your help, Gary. But I'm still having some problems.
The Artists and Comics tables were already in existence. I created a
form and subform, and I am able ot filter the artist subform to get the
results I want, but I can't get it to go into a report.
I know I'm doing this the hard way. What I really want is to start a
report that asks me which artist I want. I want to then select the
artist's name from a pulldown. The report should show only those comics
that have that artist's name in any of the artist fields from the Comics
table. This is probably much simpler than it sounds, but Access has a
real tendency to confuse me.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
