DoCmd help

[Tom]

I have a form and on that form in access 2003 I have a combo box names
combocategory.

In the combocategory after update event procedure I want to use the docmd to
change the focus to another combo box called combodish and then open the
combobox up to display choices

I used docmd.gotocontrol.combodish
combodish.dropdown

nothing happens
it highlighs the docmd line

any suggestions ?

I tried combodish in parenthesis and nothing and in brackets and nothing
happens

should I do it elsewhere then the after update event?

I appreciate any help ou can give me

Thanks

 

[Douglas J. Steele]

The correct syntax for the GoToControl method is

DoCmd.GoToControl controlname

so, in your case, that would be

DoCmd.GoToControl "combodish"

That having been said, I prefer using the SetFocus method:

Me!combodish.SetFocus