What's the name of the control?

Had to sign up before I could reply. The control name in this instance is ProvID

However it is doing it with all of them. It's like access does not understand the statecombo part of the statement

When I click on the control I get Runtime error 424 Object required

Access is not recognising StateCombo because the Combo Box is named ProvID.

Can you elaborate on that

What should it be named

Okay, which video are we talking about here? I use StateCombo in a lot of different videos. What Kevin is trying to say is that if you name the combo box itself "ProvID," then Access will not know what state combo is. It has to be the same thing as what you've named the control.

Welcome to the club and good luck on your Learning Connection journey.

Chuck

Open your form in Design View.
Select the Combo Box.
Change the Name back to 'Statecombo'

Then in your code, change 'ProvID' back to 'Statecombo'

Private Sub Statecombo_GotFocus()

    statecombo.Dropdown

End Sub

***********************************************

The problem you are running into is that you're changing the name in one location, and not the other related locations.
On the Table, the [Field] is named 'State' and is identified by 'StateID'
On the Form, the combobox is named 'Statecombo', which has a bound field: [StateID]
In your Code, the Sub is based on the control name, which should be 'Statecombo'
And the method you are trying to use is [Statecombo.dropdown].

If you change one of these names, they all have to be changed or you will get the errors you are seeing.

Also.... any Tables with Foreign Keys have to be updated, any conditional formatting has to be updated, etc.

-Raymond

Hi Guys

Thank you. I finally figured it out. I was thinkin StateCombo was an actual Access function and not defendant on whether or not that control actually existed in the form. I has been years since I did any of this. It's slowly coming back

Thanks for all the help