Recent content by jgb

I have a form and table called “pcinfo-vendor” that the customer enters some date that they need. They also need to pull up some vendor information from a table called “vendorinfo” – Vendor name, Address, City, State, Phone #, FAX # and Email. What I need help with is this – How can I bring up...

I’m still in the weeds. Is the following codes correct – where do I put them? Vender DoCmd.OpenReport "qrytbqaincomingerrors", acViewPreview, "Vender = ‘" & Me.CmbVender & "’" PO Numbers DoCmd.OpenReport "qrytbqaincomingerrors", acViewPreview, "PONumber = #" & Me.CmbPONumber &...

Thanks again for the fast help. I'll try it today.

Thanks for the info. Is there a tutorial on the web to show me how to set a criteria for the others to have them filtered?

Here is the code to open the report – On Click [Event Procedure] Private Sub Command11_Click() DoCmd.OpenReport "qrytbqaincomingerrors", acViewPreview End Sub Here is the code for the Vender combobox - After Update [Event Procedure] Private Sub CmbVender_AfterUpdate()...

I’m trying to make a form with 4-combox lists to run a report. I get all my data from one table with 4 columns called Vender, PO Number, Part Number and Defects. The problem I am having is that report only gives me the specific Vender that I choose from the Vender combox with all the data...

Thank Paul. I'll try it latter tonight.

I am trying to pull up only the PO numbers and Part numbers for only one Vender. I would like to select a Vender (Combobox1) then I need only the PO numbers (Combobox3) and Part numbers (Combobox5) for that Vender only to come up. I can pull up all the Vender names in Combobox1, all...