Save info to table other than record source

[mitchem1]

I have a form call frmPermit. The record source is tblPermit. On the form is a drop-down list for Company. When a company is selected it blows in the Company Name, Address, City, State, and Zip, all information stored in tblCompany. If the user need to enter a new company, not currently stored in tblCompany, is it possible to enter the info (Company Name, Address, City, State, Zip) on this form and have a new company record saved back to tblCompany? Thank you.

 

[Rich]

Use a combo box and the notinlist event

 

[mitchem1]

If anyone has a database with an example of this, I would like to see it. Or is there an example in the Northwind or Solutions databases?

 

[MonkeyMaster]

there is an example in the Northwind 'base but I am not sure how good it is. I am working on something similar, if I finish and remember I will send it (if it works)

 

[David R]

http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q197526