Form | Combo box ---> add new entry?

[lowtek]

Hello,

I have a combo box (employer listing) that is populated by a table (tbl_EmployersDatabase) as the row source. I have the 'Limit To List' property set to 'No' so that if the employer is not found in (tbl_EmployersDatabase), you can simply add it by typing it directly in the combo box.

I would like to know how I can make the user's manual entry in the combo box get added to (tbl_EmployersDatabase) so that it will be available subsequent to that entry.

Sounds like some vba needed so I don't know if this is the correct forum.

Thank you in advance for any help,
Rey

 

[PHV]

Check the VBA help file for the NotInList event.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ZmrAbdulla]

http://www.mvps.org/access/forms/frm0015.htm

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[lowtek]

Thanks for the replies! It took some figuring out to get the code from Dev Ashish to work, but I got it to do exactly what I wanted. Much appreciation!
Rey