I've done this before - can't think today

[Maltese]

G'day:

I am creating a dB that has several different "parts" to it and creates several different reports and such.

I am trying to create a form - frmExpenses that I can put down several different types of information to creates these multiple reports.

Part of the form has combo boxes based on information from other combo boxes.

I am having troubles getting the second ComboBox AgencyStaffCMBO populated based on the AgencyID from the first ComboBox AgencyIDCMBO.

Any help would greatly be appreciated!

 

[swedish_mania]

View this, i think this is what your asking: http://www.access-programmers.co.uk/forums/showthread.php?t=81704

Try the Search feature, it really works...lol

 

[maxmangion]

What you're looking for is Cascading Combo Boxes. Check this sample .