Search results for query: *

Thanks again Duane but when you say that I may have to build two different sql statements, where would the second one go? I placed it right under the first one (see below)but that does not work or maybe I have some other code wrong. Would you mind checking my code below to see if it is correct...

Thank you again Duane. I think that I am getting closer to getting this to work but still not there. I have rewritten my code as you suggested, see below: Public Function UpdateFilter() Dim strSQL As String Dim strWhere As String strWhere = " Where 1=1 " strSQL = "SELECT * FROM qry...

Thanks agin for you insight but my lack of knowledge with VB is making this difficult to understand. I have the following code. The first combo box deals with my item number, the second one with my Received date and the last combo box with my Shipped Date. Private Sub Combo21_AfterUpdate()...

Duane, First I want to thank you for your quick reply. I was stuck on this for about 6 hours yesterday before I decided to go to a higher power. At least you confirmed that what I was doing would never work. However I am still a bit confused as to where I should place your code. Here is what I...

I have a main form with 2 subforms. On the main form I have 3 unbound combo boxes (Item #, date received and date shipped)that I have the user select and depending on there selection the two subforms should display the matching data. The first subform contains the "received" information based a...