Missing Drop Down command in Visual basic

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have a combobox in the city field of a form. I want to have the combobox
open automatically when you leave the address field. I have done this many
times. I went into the after update property of the address field and entered
me!city.setFocus to change the focus to the city field. Then always before
when I went into the next line and typed
city.Dropdown
Visual basic help came up and the Dropdown command was there. Now even if I
type it out..... nothing happens. I remember it always had a green mark
beside it when I used it before and it came up in visual basic help. Anyway
it is gone . Can anyone tell me where to get it or why it is missing? This is
frustrating.

Thanks
 
Did you try:

me.city.dropdown

Tom,

Generally, I use one of the common naming conventions for all of my
controls, which allows me to explicitly reference the control, as opposed to
the field in the underlying recordsource. So, in my code, it would look
like:

me.cbo_City.Dropdown

HTH
Dale
 
Back
Top