working with fields

[Guest]

I have a form with a field called “Department†that has the following
entries: Real Estate, Corporate, Litigation. I have another field called
“Sub Department†that has specialty areas of the departments.

For example:

-Real Estate may have the following sub departments: condo, financing,
leasing.

-Litigation may have the following: class action, probate, securities.

I would like the user to be able to select a “department†and only make
visible the “sub departments†available to that group.

Can anyone tell me how to accomplish this? Any help would be greatly
appreciated.

Thanks,
Alicia

 

[John Vinson]

I would like the user to be able to select a “department” and only make
visible the “sub departments” available to that group.

Can anyone tell me how to accomplish this? Any help would be greatly
appreciated.

You need just a little bit of VBA code to do this, but it's easy. Try
the second example at

http://www.mvps.org/access/forms/frm0028.htm


John W. Vinson[MVP]

 

[Guest]

Thanks John.

You need just a little bit of VBA code to do this, but it's easy. Try
the second example at

http://www.mvps.org/access/forms/frm0028.htm


John W. Vinson[MVP]