Thanks again. I think I'm starting to get it. Here's the problem, though. There are actually five combo boxes (Artist 1, Artist 2, Artist 3, Artist 4, and Artist 5) that I use for my data entry. I want to display the comic info for all comics where the artist's name appears as Artist 1, Artist 2, Artist 3, Artist 4, OR Artist 5. There is one table for all the artist's names, and I use that table for all five of the combo boxes, but the info is stored in five different fields in my "Comics" table when I enter it.
--- In [email protected], "Crosier, Dawn" <[EMAIL PROTECTED]> wrote: > > Gary - > > OK, I am not sure what the fields are that you are using, but I will > attempt to modify the code to suit your needs: > > > If Me.cboArtistName.Value <> "" Then > > strWhere = "[Artist]=" & "'" & Me![cboArtistName] & "'" > > DoCmd.OpenReport "MyArtistReport", acViewPreview, strWhere > > Me.cboArtistName - is the name of the combo box that you are using to > select which artist to generate the report about. > [Artist] - is the name of the field in your report. > MyArtistReport - is the name of the report that you want opened and > filtered. > > This code goes under the button that you will click to create your > report. For instance, I have a button on my form that I click after I > select the proper Ingredient that I want recipe's for. > > Does that help? > > 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: Wednesday, March 22, 2006 12:01 PM > To: [email protected] > Subject: [ms_access] Re: Report help > > Thanks, Dawn. But I don't have a clue how to use that. > 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/
