Full Version: Change a Combo Box Value based on another Combo Box, Different f
UtterAccess Forums > Microsoft® Access > Access Forms
bizper83
Im trying to Change the Value of a combo box in a subform on the after update of a combo box in the primary form but im not bump into a wall, for some reason it doesnt like my below syntax:
orms![frmnotes].Forms!frmvariablestest.form.cbobusiness = Me.Combo13
DougY
Search the site for 'cascading comboboxes' ...
Here is one post (out of many) about it.
HTH
fkegley
I think your syntax is bad.
Try this instead:
Forms![frmnotes].[NameOfSubformControlGoesHere].form.cbobusiness = Me.Combo13
HiTechCoach
I agree with Frank. You have a synatx problem.
lso try this:
Forms![frmnotes].[frmvariablestest].form!cbobusiness = Me.Combo13
I have always used the ! where Frank has a .
bizper83
Thanks for the respond, I found what I was doing wrong! I was trying to change a bound combo box! I found a work around. thanks
fkegley
I'm glad you found the problem and found a way around it.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.