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.
Armen Stein
Microsoft Access MVP
www.JStreetTech.com