options

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table in which a field has values L (long term
disability), A (available). I would like to create an
option group with L,A,S (short term disability) in a from
to facilitate data entry. But, when I create an option
group, the values are stored as numbers. I need L,A,S
because some of these values already exist in the table.

Eg Employee1 S

If he goes on longterm diability, the user should be able
to check L.

Thanks
 
Have a look in Access Help about Combo boxes. You'll need
one with predefined manually entered list of values. You
may well have the combo box design wozard on your Access.
 
thanks Nick
-----Original Message-----
Have a look in Access Help about Combo boxes. You'll need
one with predefined manually entered list of values. You
may well have the combo box design wozard on your Access.

--
Nick Coe (UK)
www.alphacos.co.uk

---




.
Click to expand...
 
1. You can simply change the existing Table to store 1, 2 or 3 and use a
LookUp Table translating 1 to Long-term Disability, 2 to Short-term
Disabilty, 3 to Available, etc ...

This would be the simplest way and you can use ComboBox like Nick advised.

2. If you still want to use OptionGroup but want to store the values as
"L", "S", "A", you can create a hidden TextBox which is bound to your Table
Field (in the RecordSource of your Form).

You can then use the OptionGroup_AfterUpdate Event to assign the value of
the TextBox depending on the value selected in the OptionGroup.

If your Form is also used for viewing / editing existing Records, you will
also need to use the Form_Current Event to assign the value (1, 2 or 3) to
(unbound) OptionGroup depending on the existing "Availability" value of the
current Record.
 
Back
Top