lookup tables and avoiding lookup wizard

[Guest]

I am aware of the problems of lookup field in tables, and have designed my
database without them. However, on data entry forms, it is very time
consuming having unbound comboboxes. I have been grabbing data from the
comboboxes and using VB to add the data to the appropriate fields in the
tables. Is there an eaiser way to have a combobox lookup values from a
table, but still be bound to the field in the record you want to have the
user enter data for?

Thanks!
Scott D. Collins

 

[Guest]

Alrighty Then....
Hopefully no one will even read this post...<sigh> I figured it out
myself...duh. I didn't know (or think) that you could set the row source
different from the control source. Oh, well...that's why I post the the 'New
Users' group.