How can I display the values of one combo box based on another? For instance, I have a Hospital Combo box and I want only the units for that hospital to appear in the Units Combo box.

I have two tables (Hospital and Hospital Unit) which are linked by hospital Unit.

Thanks!!

Follow the link below for help, it's not as hard as it appears.

http://support.microsoft.com/support/kb/ARTICLES/Q97/6/24.asp

HTH
RDH