Recent content by Ebweaver

It works great! Thank you so much, now I have some designing to do to make it look nice. :D

I just add that in under the other code before End Sub? Edit:Nevermind I see it's already all there.

Report name is rMediaContacts

Oh I see, there was no record source - it's set to tMediaContacts now. I feel dumb. So now when I click my filter button, it will find based on my search criteria - then I need to create a report that I click to open after I hit the filter button?

Yes, I have it set up just like that. The filter command button and combo boxes are in the Form Header - and the default view is set to Continuous Forms.

Okay it seems like no other problems with the code, however when I click the filter button nothing happens. Is this when I need a report or subform for the data to show up in? Also, thank you so much for your help on this.

Table = tMediaContacts Form = fSearch Button = cmdFilter Combo1 = cmbLocation Combo2 = cmbCategory Combo3 = cmbCity

Hmm, removed those lines but still getting the same: On the same line as before.

Yes, I did.

Do I need to create a report or a subform for the data to display in? I'm getting an error with this line: Private Sub cmdFilter_Click() I named my button cmdFilter however.

No rush at all! I appreciate the help.

I haven't made the report yet, I just wanted it to search the data correctly first.

I can set up the form that way if possible - right now it's just simple with three combo boxes for three search fields and a run query button.

Well sure! I trust you that the code is probably the better way, it's just new to me. What all do you need to know?

GinaWhipp - thanks for the quick response. I understand little to no code (new to Access) - how would I go about applying that code to my search form? Should I even bother with trying with a query like at the bottom of that link?