Set Focus to Subform ctl that match combobox selection main form

[Graysen via AccessMonster.com]

i have a combo box on my main form. i want to choose a name from the combox
and have the control/name selected by setfocus in the subform.

here's my code. right now it just goes to the first record in the subform.
it doesn't match the combox name.

the name of the combox = name
Once I select a name, I click on a goto button and behind the button is this
code.....

With Forms![frmMain].[qryCost_subform]
.setfocus
.form![id.code].setfocus


the id.code is the code associated with the name on the combobox.
I get '"object doesn't support his" or if I use ![qyCost_subform] it errors
with "can't find subform"

thanks for your help


Graysen

 

[Guest]

There is no reason to have a main form with just a combo box on it and the
data is in the subform.
My standard answer to combo boxes please take a look at Allen Browne's
website and learn about combo boxes.
http://allenbrowne.com/ser-03.html