Letting Users Set a Default Value

[DBL]

I'm looking for some suggestions. I have a database that is used by various departments and each department has their own backend. The main form is made up of 12 combo boxes and all departments have the same options. I'd like the administrator for each department to be able to set their own default value from the list of values available. What's the best/simplest way to do this. I was going down the road of a tick box to select the default option but I'm not sure how to call the selected value each time a new record is created, or have the ticked value automatically show in the combo box when a new record is opened.

Thanks

D

 

[Parker]

I'm looking for some suggestions. I have a database that is used by various departments and each department has their own backend. The main form is made up of 12 combo boxes and all departments have the same options. I'd like the administrator for each department to be able to set their own default value from the list of values available. What's the best/simplest way to do this. I was going down the road of a tick box to select the default option but I'm not sure how to call the selected value each time a new record is created, or have the ticked value automatically show in the combo box when a new record is opened.

Thanks

D

I've had a think about this and because no one else has answered I have decided to give it a go.

I can think of a number of possible ways of achieving your request but a lot depends on what is behind your combo boxes.

i.e Where/how do they get there information?
Are they casscading?
Are they the result of a query?

Post an example and lets have a looksee.

 

[Rich]

Save their choice to a table then use DLookUp to get their chosen value