populating textfield using combobox access 2007, sql 2008
Posted on 2011-09-17
Have a subform in my form:
There is a combo box which displays taskID and TaskDescription and bound TaskID to the combobox. and should display taskdescription in the textfield beside it and then automatically display the next row of combobox and textfield for the second entry.
The problem I have, I can not populated the textfield after making a selection. I keep getting #Name? in this text field.
Here are how combobox and textfield set up:
control source: TaskID
AfterUpdate:Event Procedure : Me!Task = cmb_task.Column(1)
control source: taskID
row source: select taskID, task from task bound column: 1,
Date: control source: TASK
how can I get this fixed. (when I make the task textfield unbound, then it does not add the second row...)
thanks in advance