Using Combo Box on a form

[angie]

I have a table named "customers" with a field name "Address" which is a text field.
I have a form that has the "Address" Field in it that is a combo box which the row source is looking up the " Address" in a table "Address"
My question is should I have made the field "address" in the customers table a lookup combo box linked to the table address?


Thanks Angie

[pbaldy]

Most of us would say no:

http://www.theaccessweb.com/lookupfields.htm

[angie]

great information, But what I have is a split database on a network and the address field combo box is slow to respond. That is why I was thinking I had it set up wrong....

[pbaldy]

Are there a lot of records? Perhaps something like this if so:

http://allenbrowne.com/ser-32.html

You can also load them into a local table when the app starts.