jvan2008
Last Activity: Mar 2 '09, 03:48 PM
Joined: Mar 4 '08
Location:
-
Well thanks for all your help sport -
Well lets see the title is "Create reports based on multiple combo box selections". Im going to say, how do I do it? or maybe, why isnt my code working? I thought it was prety obivousLeave a comment:
-
Create reports based on multiple combo box selections
"Form1"
combobox "cboModel"
Row Source
combobox "cboContactName "Code:SELECT [tblModel].[ID], [tblModel].[Model] FROM tblModel ORDER BY [Model];
quick explanation: I have a table named tblCOntacts and in this table i have 3 fields "LastName" and "FirstName" and...Code:SELECT [Query1].[Contact Name] FROM Query1 ORDER BY [Contact Name];
-
Private Sub Submit_Click()
DoCmd.OpenRepor t "Comic_List ", acViewPreview, , "(tblTitle.Titl eName=[Forms]![Comic_List]![titleName]) and (tblArtist.arti stname=[Forms]![Comic_List]![artistName])"
End Sub
-----------------------------------------------------------------------------------------------------------------------
I input this code into the form and it works BUT first a msg box comes up...Leave a comment:
-
I am a little confused with your posting.
My 1st combo box is named: titleName
second combo box is named: artistName
the report is named: Comic_List
titleName is in tblTitle
artistname is in tblArtist
Both have Primary keys:
Title_ID
Artist_IDLeave a comment:
-
Okay how do you do this for two combo boxes?Leave a comment:
No activity results to display
Leave a comment: