Selecting a bropdown box and making it run

[p4man]

I have a dropdown box that gets its data from a query, there is only one record thats fine.
I use "Me.ComboBox = Me.ComboBox.ItemData(0)" to display the first record (and only) that displays in the seen part of the combo box
but it wont "run" until I click on the arrow and select the same result. I need it to do it after the result is put in from the query
Any help would be appreciated.

 

[isladogs]

@p4man
I moved your thread from Sample Databases which is a moderated area not intended for members' questions.

Try adding that code to the AfterUpdate or OnChange events
However, from your description, do you need a combo here? Why not use a textbox?

 

[Deleted member 147267]

Are you trying to do this in form load event? If so, I believe you will have to do a timer trick. Regardless, more info would help to narrow the focus of responses.