Limit to list property

[briank]

I am working with a form (data source tblExpense) that
has includes a combo box which is based upon another
table (tblVendor). The first column displayed in my
combo box is the bound column. I have the Limit to List
property set to "No" yet I can't add new data in this
field. For what it's worth I can enter data directly
into the table tblExpense. Any ideas as to why I can't
enter new data into my combo box?

 

[Guest]

Hi,

You might want to add code in your AfterUpdate event to save the data in the
tblVendor table.

 

[Allen Browne]

The NotInList event will not fire unless you set Limit to List to Yes.

You should be storing the VendorID in tblExpense? This is the visible bound
column that you want users to be able to type? If so, see:
NotInList: Adding values to lookup tables
at:
http://members.iinet.net.au/~allenbrowne/ser-27.html

However, it might be easier to use the DblClick event of the combo to open a
form where your users can enter not just the VendorID, but the vendor's name
and contact details as well. You can then use the AfterUpdate event of that
form to Requery the combo so the new entry shows up.