Questions about 4-button option group and organizational chart fromAccess?

[Lostguy]

Hello.

a) Found lots about 2 button option groups, but not that much about
more than 2.

I have an option group with 4 radio buttons with output 1,2,3, or 4.
(ogCivMil)

The buttons are (select one) Military Staff,Civilian Staff, Military
Other, and Civilian Other (contractors, etc.).

For the two military selections (1 or 3), I need comboboxMilitary
enabled. If 2 or 4, it is disabled.

For the two civilian selections (2 or 4), I need comboboxCivilian
enabled. If 1 or 3, it is disabled.

I am using Me!comboboxmilitary.enabled = Not(Me!ogCivMil = 2), but I
can't get the OR right to make it for both 2 OR 4.

So what's the best way to set up the "combox is disabled if option
group output is X OR Y?

b) Now that I have everyone's personal data entered into my Access
2003 database, does anyone know if there is some code or other to use
this to make an organizational chart rather than retype the names into
some other program?

Thanks for all the help!

VR/

Lost

 

[Pete D.]

Use a number to set level for each person (ms project good example) and also
Access isn't secure so keep it in house protected by network security.

001 = CC Staff
002 = Admin
003 = Personnel Troop
004 = Joe Billy Bob

So your key would be 001.002.003.004 equals 4th level in the org chart.

Oh by the way, if there is a SSAN in the Access file, delete it now or you
may be ending your career.

 

[John Spencer]

Unless I completely misunderstand you should be able to use.

Me!comboboxmilitary.enabled = (Me!ogCivMil = 1 or Me!ogCivMil = 3)

Me!ComboboxCivilian.enabled = (Me!ogCivMil = 2 or Me!ogCivMil = 4)

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Lostguy]

John,

Thanks!

I was trying "Me!ogCivMil =2 or 3", etc. and none of my many attempts
worked.

Your way (the correct way) is what I needed.

Thanks for your help!

VR/

Lost