Hi,
I have managed to create a tab with a subform displayed as a database.
The subform is based on a query that picks criteria from a combobox above.
In the combobox I have 3 people no 1,2,3 i have set a default value of 1.
Starting the form works nicely and the def value is given to the query.
Now
How do I write an action when I change the combovalue to update the subform.
I managed to run the query but I want it to update the subform below the combo.
Lets call the subform "todo_pers"
Maybe I have misstyped the criteria as well , the combo is named "who" and the criteria states [Forms]![who].
The default value works initially.
As the combo has columns 1-no , 2-name with display on 2 , do I need to specify wich column to pick.
Thanks in advance!
P