I have a table and have created a form and when I do my combobox, anything that is in that first column depending on what someone chooses from drop down should display all the data in my text boxes. I have the code set up as follows:
private sub skill_afterupdate()
me.ques1 = me.ques1.column(0)
me.ques2 = me.ques2.column(1)
etc....
there are a total of 21 columns in this table with skill being in column 1 and the questions in columns 2 through 21. There are 4 possible choices from the skill and when the drop down is chosen it will display whatever the questions are pertaining to that skill. When I try and get in my form view and choose a question I get this error:
compile error: method or data member not found and it has .column highlighted. If I look further by clicking help it says the collection, object or user-defined type doesnt contain the referenced member. I am not sure what that means.