Combobox Not In List

[David M C]

Tables:

Orders:
OrderID pk autonumber
SupplierID fk
OrderDate
etc

OrderDetails:

OrderDetailsID pk autonumber
OrderID fk
Description
Quantity
etc

Suppliers:

SupplierID pk autonumber
CompanyName
Address1
Address2
City
etc

On a form, I have the usual Order, Order Details setup. In the main form I
have a Supplier combobox, bound to SupplierID in the orders table, but
showing CompanyName. The address information is displayed in text boxes
depending on the supplier selected.

Quite often, an order will be placed with a new supplier. The users often
try to enter the new company name in the combobox and the address information
in the text boxes below. How can I have this information added to the
Suppliers table? The combobox is currently set with Limit To List = Yes. At
the moment, I make them use a seperate form to add the new supplier but it is
quite longwinded and more importantly, not what they expect to happen.

Thanks

Dave

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "NotInList.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[David M C]

Thanks, exactly what I was looking for.

Dave

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "NotInList.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L