Limit to List difficulty

[cjtemple]

I am looking to put a combo-box on a form. The box is set to query Table2 and get the ID, and Type. The selected index will store the ID in Table1.Type. I would like to hide the Index column and set the combo-box to Limit to List: NO so that the user can either click on the Type or Type in a new Type which will be added to Table2. Can anyone help me with this one. When I try to set Limit to List to NO, Access yells at me because my first column is hidden and I have to fix my Columnwidth then set Limit to List to NO.

My Database:


Table1:

 
ID - autonumber
Type - number
Description - text

Table2:

 
ID - autonumber
Type - text

Table2.ID has a one to many relationship with Table1.Type

[Rawb]

I'm not sure you can do what you want from just a single Combo Box.

I'd recommend having a Combo Box that lets you select an existing item from the second Table and then a Button beside the Combo Box that opens a Form for creating a new type.

Then you can have the On Close event of your "New Type" Form refresh the RowSource of your Combo Box to include the new type you just created.