Requerying Combo Box

[djclntn]

Why do I struggle so much in getting my Combo Boxes to Requery? In the 'Events Tab" where do I put my requery expression? Isn't in "AfterUpdate?"

[ssanfu]

If you are referring to cascading combo boxes, I use the after update event of the primary (first) combo box.

[djclntn]

What is cascading combo boxes? Here's what I have:
Private Sub Combo44_AfterUpdate()
Me.Combo44.Requery
End Sub

[ssanfu]

cascading combo boxes: See http://access.mvps.org/access/forms/frm0028.htm

Why are you trying to requery the same combo box you just made a selection in?

[djclntn]

cascading combo boxes: See http://access.mvps.org/access/forms/frm0028.htm

Why are you trying to requery the same combo box you just made a selection in?

In my Combo Box I have the 'CustomerrsID' & the 'NumofVehiclesPurchased.' Now the Combo Box is from a query that list all of my customers who have yet purchased a vehicle. So, when I choose/assign a CustomerID to a vehicle (a Sale) when I go to the next Record & need to pick another Customer ID from my Combo Box I just want to ONLY see those customersid who have "0" Vehicles. Might you be following me a little?

[ssanfu]

What is the row source of the combo box? Something like

SELECT CustomerrsID, NumofVehiclesPurchased FROM tblCustomers WHERE NumofVehiclesPurchased = 0



When you move to a different record, the combo box should be refreshed (requeried).
You might try

Private Sub Form_Current()
   Me.Combo44.Requery
End Sub

[djclntn]

I tried pasting your code & it didn't work I get an error

Here's the Row Source: SELECT [Customers CountOfVehicles (0)].[CustomerID], [Customers CountOfVehicles (0)].[Age], [Customers CountOfVehicles (0)].[MonthlyIncome] FROM [Customers CountOfVehicles (0)];

Maybe I need to eliminate the 'Age' & the 'MonthlyIncome'? Could that bbe the issue?


I tried it with just the customersID ALONE! Still NOT working for me