combo: multiple columns with a value list

[Jack Leach]

Here's one that I'd like to pull off but haven't come across yet.

I have a combo that's bound to an integer field. Let's say fldStatus, 0 for
inactive 1 for active.

I want to show, in the combo box, Inactive and Active, but still have the
bound as an integer.

I currently do this by using an SQL Rowsource:

"SELECT * FROM tblLookups WHERE fldGroup = ""Statuses"""

but I would like to get away from this tblLookups, which is a cumulation of
various lookups that are identified by group.

So I want a value list of "Active"; "Inactive" with a binder of 0 and 1

Make sense? Is it possible? Thanks for any thoughts

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)

 

[Jack Leach]

Never mind... apparently an 18 hour day is getting to me.

Value List: 0;Inactive;1;Active
Column Count: 2
Bound Column: 1
Column Widths: 0"; 1"

That'll do.

Thanks,
--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)