Armen Stein wrote in
:

On 27 Jan 2010 02:41:33 GMT, "David W. Fenton"
wrote:

I never bother with that. I just base the combo box on the unique
values for the data field it's bound to. This does require a
hidden field for saving the data before requerying the combo box,
but it's so much easier that mucking around with maintaining a
lookup table.

Good point. We've done the unique values approach too, but you
can run into performance problems on large recordsets.

....in which case a combo box is likely not the correct interface
control (or you need to prefilter it, which means its recordsource
has to be a UNION with a SELECT statement returning the value for
the current record and it has to be requried on each row).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/