ADOX Lookup Field

[iXPhound]

Hi all:

I basically a newb looking for assistance. I hope someone can help me with this one.

If you go to the design view of a table, you can go to the lookup tab for a text field and set the display control to combo box, and then set the row source and type.

I am creating a database and am attempting to create tables using ADOX but I have no idea how to set the display control and rowsource, etc.

Any ideas are greatly appreciated.

TIA!!!!

 

[oharab]

The easy amswer is don't!
Have a look at Commandment 2 at

http://www.mvps.org/access/tencommandments.htm

Combo boxes are there to aid input. Inputting should be done on a form, not in the table, therefore there should be no way of putting combo boxes on tables.

Unfortunately noone told M$ this.

Just my thoughts on the matter!!

B

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"
NoFX-The Decline
----------------------------------------------