DoCmd help

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

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
 
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
 
Back
Top