How to create this Query?

[djclntn]

I have 2-Tables – a CUSTOMERS Table which lists ALL of my customer’s info with a CustomerID. My second table is my VEHICLES tables which contains ALL of the Vehicles info. I’m able to create/run a query which shows how many vehicles per customer. However, those customers who haven’t purchased a vehicle yet how do I see them also? In other words, I need a query which shows me ALL of my customers, those who have brought & have yet to purchase a vehicle. With this such query I can (my objective) is to create a Combo Box that displays the CustomersID & the number of vehicles purchased (including the customers who have “0” vehicles). I hope to have explain my objective clearly

[pbaldy]

In design view, right click or double click on the join line to edit it. The correct selection should be obvious at that point.

[kwolfel]

Like pbaldy states, you want to right click and choose join properties. From there, you have the option to choose all records in the customer table and only those from the vehicle tables where the tables are equal. This will pull in all records from the customer table like you want.

[pbaldy]

I must not have stated it well enough?

[kwolfel]

I'm sorry - I didn't mean to offend. I just know when I'm searching for an answer it always helps when the answers are specific, especially if you're just starting out and aren't familiar with joining tables. I just figured it might help to add a little extra detail.

[djclntn]

Yes, I thought to have acknowledge & thanked pbaldy for his suggestion which worked welln. As well, thank you for following up :-)

kwolfel:
Do you know what is the magic portion in getting your Combo Box to Requery after making a selection in a Record? Ling, (no offense) told me to go on the Event Tab & in the On Current type the code, “Me.Combo25.Requery” (the Combo Box name is Combo25). I have no reason to doubt Ling’s knowledge, yet it’s not working for me. Or, maybe I’m not clear on my objective. When I add a CustomerID to a Vehicle (on a Form) within my CustomerID Combo Box tells me how many vehicles a customer purchased (even those customers who have yet to purchase “A” vehicle) So, when I click on a customer & I go to another Record the number of vehicles should change after the last inputted customer in my Combo Box, but it doesn’t. Yes, I could hit Refresh ALL which will Requery my Combo Box, but by hitting Refresh ALL puts me back to the first Record. Might you have any insight?

[kwolfel]

djclntn,

I normally would use "AfterUpdate" to requery. On the CustomerID Combo Box, go to the event tab and create an event [press the ... button] at the AfterUpdate. In code, you want to requery your Vehicle combo box similar to what you have done above. This will update your vehicle combo box always after the customer combo box is updated. It should look something like below (you'll only need to add the requery part) and just update the "VehicleCombo" with your combo box name.

Private Sub CustomerID_AfterUpdate()
Me.VehicleCombo.requery
End Sub