Macro Action

[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

[TheShabz]

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