Thanks, Dawn. But I don't have a clue how to use that.
--- In [email protected], "Crosier, Dawn" <[EMAIL PROTECTED]>
wrote:
>
> 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/
