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/
