I'm having issues setting a multi-column combobox in the right way.
What I'm trying to do is that when I click on a table (access 2007 subform), a form should fill with the values of the record I clicked on.
No problem until I have to fill correctly a multi-column combo for 2 reasons:
- In the table I only have the value of one of the 2 columns (That can be solved if I query again one of my external tables, but if you have another way of doing it, I would appreciate it.... maybe something like mooving the selected option of a combo until it matches my value but no idea if that's possible)
- When I try to set the value of the second column of my combo like this:
Expand|Select|Wrap|Line Numbers
- [Form_Tool Administration - Manage Users].CBoxProfile.Column(1) = Profile
Runtime Error 424: Object RequiredThe funny thing is that it actually sets my second column to the value I want, but I keep having that error. The form, combobox control and column exist... and I actually have the right value in my variable "Profile".
Could you help me with this issue, please?