Easy Update Option Group

[Shawn29316]

Hi,
I have a split database which contains a couple of forms with option groups. These represent people in roles like industrial engineers. Since people change jobs from time to time, I'm looking for a simple way that I can manage the entries (options) in the option group, without having to redistribute the front-end of the database every time someone changes jobs.
For example, today's list should include Sally's name but tomorrow, her name should be replaced by Joe's name. Again, my only goal is to NOT have to redistribute the front-end.

I'd appreciate any advice!

Thanks,
Shawn

[nico5038]

The only way I see to solve this is to code the value's (captions) in VBA based on data in a table. When the number of options is fixed, it's not too dfficult, however when the number can increase, then the coding will have to reshape the optiongroep and number of options...

Getting the idea ?

Nic;0)

[Shawn29316]

Thanks Nico!
I'm not a great programmer and I thought flexing the size of the group would be over my head.....and it seems I was right.
I appreciate the help!

[PhilOfWalton]

Have you considered a Job Description table. You then have 2 Options (Excuse the pun)

1) Change the name of the Job (Globally) e.g. "Engineer" to "Industrial Engineer"
2) Against each Employee have a Combo Box to select their Job.

Phil