Using a combo box in a subform data sheet

L

Laphan

Hi All

This is going to sound bizarre so I hope you can pick out what I mean from
my ramblings!!

Basically I'm using VBA to populate the recordsource of a subform so that I
have 4 textbox-style fields and 2 combo-box fields.

Now my database fields for the combo boxes consist of 0 for active and 1 for
disabled, but I want the data in the combo boxes to show something more
relevant, eg

My Type field will consist of 0 or 1, but in the actual combo box where it
shows the current value I want it to show Active if 0 and 1 if disabled and
if they click the drop-down menu I want them to be able to pick Active or
Disabled, but in essence this will put back 0 or 1 into the database.

Does that make sense?

Is it possible?

NOTE: the reason I'm using byte fields to store 0 and 1 rather than text or
boolean is because these may expand later and I might have different states
such as 0 = Active, 1 = Disabled, 2 = On Hold, 3 = Archived, etc

Thanks
 
Top