Lookup by code

  • Thread starter Thread starter Torben Christiansen
  • Start date Start date
T

Torben Christiansen

Hi

Is there anyway to change a table design and make a lookup on one of its
columns by code? I want to change the displaycontrol to a combobox and I
want to change the Row Source, column count, and column width. All this I
would like to do by code, but is it possible and how?

Torben
 
Torben Christiansen said:
Hi

Is there anyway to change a table design and make a lookup on one of its
columns by code? I want to change the displaycontrol to a combobox and I
want to change the Row Source, column count, and column width. All this I
would like to do by code, but is it possible and how?
Click to expand...

Tables should never be used for anything but storing and validating data. I
suggest you read the following articles before using lookup fields in a
table:

http://www.mvps.org/access/tencommandments.htm
http://www.mvps.org/access/lookupfields.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
I know this, but I still would like to know if it is possible and if it is
then how to do it

Torben
 
Back
Top