What is the code for requerying a Combo Box?

[djclntn]

I Goggled "how to refresh combobox in access" & I found this code:

Private Sub Category_DblClick(Cancel As Integer)

'Open code table
DoCmd.OpenForm "CategoryCodes", acNormal, , , , acDialog
Form_Suppliers!Category.Requery

End Sub

So. I implented this code into my Form. My Combo Box is a list of 4-CostomerID & how many Vehicles purchased (including those custmoers who have yet to purchased a vehicle). When I assign a customer to a vehicle in my Combo Box I want to see how many 'Vehicles' per customer after i imput a customer on my Forrm. To avoid having to hit Refressh & going to Record 1 there is a way i can Refresh/Requery my Combo Box unon going to the next Record, Right?

For 'Table' I used the Forms' name?

Here's the code I tried, but doesn't work

Private Sub Combo53_DblClick(Cancel As Integer)


'Open code Vehicles SUMS_Customers
DoCmd.OpenForm "Combo53", acNormal, , , , acDialog
Form_Vehicles SUMS_Customers!Combo53.Requery

End Sub

[Missinglinq]

To be honest, your stated scenario is murky, to say the least, and I have no idea what your code is supposed to be doing! You appear to be opening a Form named Combo53, which, I assume, is actually the name of your Combobox! If your object is to Requery a Combobox named Combo53, each time you move to a New/Different Record, try:

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

Linq ;0)>

[djclntn]

Ling,

Where do I put the code, in AfterUpdate or On Enter...?

[Missinglinq]

You put it in the Form_Current event, just as I posted it.

Linq ;0)>

[djclntn]

No luck lin, I did exactly what you said, Close the Form, reopened the Form. When I tested my Combo Box & chose a customer that has 1-vehicle, clicked on their name for a second vehicle. when i went to a diffgerent Record, pulled down my customers combo box the customers who now brought 2-vehicles is still showing "1" in the combo box (list)

I'll get back at this tomorrow...thanks

[djclntn]

Ling,

I did what youi had instructed me to go on the Form Property, on the Event Tab & in the "On Current" type in the code: Me.Combo78.Requery. the Combo Box is named, 'ComboBox78'. I save, close the Form, reopen the Form, put in a customer in a Record, but the ComboBox doesn't update when I go to another Record. Ling, could the ComboBox not requerying/updating because i'm not going on a "New Record?" is that my hang-up?

[Missinglinq]

...on the Form Property, on the Event Tab & in the "On Current" type in the code: Me.Combo78.Requery...

If you're saying that you went to Property Pane for the Form, went the Events Tab and then, in the box for the OnCurrent event, typed in

Me.Combo78.Requery

that won't work! The code I gave you

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

has to appear, just like that, in the Code Module for your Form. You cannot simply enter it into the OnCurrent Property box!

Linq ;0)>