VBA Code to filter values on a combo box from another combo box

[system243trd]

I have a form containing two combo boxes that use two SQL stored procedures to return data. When the form opens, information for both form is retrieved.
Field1

Field1

A

B

C

Field2

ColumnA	ColumnB
A	Answer1
A	Answer2
A	Answer3
B	Answer4
B	Answer5
C	Answer10

I have hidden Column A for field 2 by adjusting the widths.
Please could someone provide me with the VBA code after field 1 has been updated, to filter ColumnB based on Field 1 matching on Field2ColumnA e..g if B is selected for field1, then Answer 4 and Answer 5 will be displayed.

[Bob Fitz]

Try searching the forum and google for "cascading combo boxes".
This link may be of help: http://www.baldyweb.com/CascadingCombo.htm