Hi Everyone,
I can't set a macro using Set Value action
for a combo box
Examole I have 2 combo boxes
I have to select the Item in the 1st combo box
then the 2nd combo box display thea list.
Thanks
Bakar
Hi Everyone,
I can't set a macro using Set Value action
for a combo box
Examole I have 2 combo boxes
I have to select the Item in the 1st combo box
then the 2nd combo box display thea list.
Thanks
Bakar
Have the 2nd combo populated by a query that uses the first combo as a criteria. Then set the AfterUpdate event of the first combo to Me.Combo2.Requery in the VBA window.
Example:
First combo holds a query...
SELECT * FROM Table1
Second combo holds query
SELECT * FROM Table2 WHERE Field1 = Forms!formName!Combo1
More info here:
http://www.baldyweb.com/CascadingCombo.htm