Another quickie...

[Nightowl4933]

...I hope!

So, this form I've got that shows a lot of information, has an Option Group which is populated from the data source table and I want to show/hide other controls, based on which option is selected.

I can do this when the Option Group is updated easily, but when I move from record to record, the controls all become visible again.

Should I be using Mouse Up/Down to set the view options?

Thanks

 

[Ranman256]

if these options apply to each and every record diffently, then you must read the settings at form_on current event

if they apply once to all records, then
youd read the options at form_load event.

 

[arnelgp]

dont bind the option group to a field in the table.
use after update of option group to hide/show controls.
use current event of form to show/hide controls also, inquiring the value of option group.

 

[Nightowl4933]

if these options apply to each and every record diffently, then you must read the settings at form_on current event

if they apply once to all records, then
youd read the options at form_load event.

They do apply to each record individually, but I can't find the form_on event!

 

[Nightowl4933]

dont bind the option group to a field in the table.
use after update of option group to hide/show controls.
use current event of form to show/hide controls also, inquiring the value of option group.

I have to bind them to a field in the table, because I'm using a query elsewhere for a report. Also, the data source is from Excel, and I've already had a nightmare in trying to prepare that data for Access! :banghead::banghead:

Pete

 

[Nightowl4933]

They do apply to each record individually, but I can't find the form_on event!

YES I CAN! Gosh, I'm such a fibber

Thank you