Missing Drop Down command in Visual basic

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
 
D

Dale Fye

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top