Search results for query: *

Thanks Again

Okay one last question, How do I set the value of combobox 2 to be dependant on combo box 1. example: combobox 1 = titleName = X-Men combobox 2 = artistName= should only be the artist that have done x-men but in mine it list all artist, so if i select a random artist and he didnt do x-men a...

I guess what I sent you wasnt what I had open, the changes must not have applied or something, But thank you so much, I have Been working on this for three weeks

DUDE YOU ARE AWESOME!!!!!!!!!!!!!! THANK YOU!!!THANK YOU!!!THANK YOU!!!THANK YOU!!!THANK YOU!!! YOU ROCK!!!!!!!!!!!!!!

It isnt letting me past this part: ![titleName] and why did you add a combo box artist when there was one in there?

Where did you put that code? I pasted it into my Comics form and it says compile error or method not found

I am not using that code any more, I am using this one because it works better then the other one: -------------------------------------------------------------- Private Sub Submit_Click() DoCmd.OpenReport "Comic_List", acViewPreview, ,_ "(tblTitle.TitleName=[Forms]![Comic_List]![titleName])...

Cant attach, im not paying to attach this to some file storage place sorry. Also the form is not bound

Im not sure what you mean by a sampl db. But to answer your question, yes i entered the same values in and it works justy right, i just dont want the msg boxes, i want it to recognize the values in the combo boxes

It Generates a blank report The first thread i posted on here the code works as far as generating the correct report it just had those pop up boxes

Run time error 2450 Microsoft Office cant find the form 'Comic_List' referred to in a Macro expression or Visual Basic code ------------------------------------------------------------ That makes sense because 'Comic_List' is a report not a form What now?

tblTitles --------- Title_ID (pk) titleName tblArtist --------- Artist_ID (pk) aritstName tblComics --------- Comic_ID (PK) Publisher_ID (FK) Artist_ID (FK) Writer_ID (FK) Edition Volume Purchase Date Publish Date Market Value Description Attachment (Picture) Comics (Form) -------------...

Private Sub Command10_Click() 'On Error Go To Err_Command10_Click Dim DocName As String Dim stFilter As String Dim lgtitleName As String Dim lgartistName As String strFilter = "1=1" If Not IsNull(Me.titleName) Then strFilter = strFilter & " And [Title_ID] = " &...

I got this little code to work to open one combo box selection to generate the right report.But dont know how to add a second combobox selection to it. Also created a qry that calls the titlename and artist name. No one seems to know how to do this. I have not been able to find the answer to...

Private Sub Command10_Click() 'On Error Go To Err_Command10_Click Dim DocName As String Dim stFilter As String Dim lgtitleName As String Dim lgartistName As String strFilter = "1=1" If Not IsNull(Me.titleName) Then strFilter = strFilter & " And [titleName] = "" &...

In another post you said something about the combo box being multi select? If what you mean by that is that when you click the drop down arrow on the combo box that you have multiple options like for example my titleNmae combo box has 55 different choices to choose from , in other words there...

strFilter: 1=1 And [titleName] = " & Me.titleName & "

Yes I tried the code from that posting it didn't run though, it gave the error that i posted above. The data types for Title_ID and Artist_ID are Auto-number.

actually it doesnt work Run time Error '3464': Data type mismatch in criteria expression this is what is highlighted: DoCmd.OpenReport stDocName, acPreview, , strFilter

Still does the same thing, pulls up all the records in the report not the specfic ones selected in the combo boxes