Add 'Edit' To Lookup Table

[NotVeryTechie]

Hi there

I have a lookup table that will be used in a combo box on a form. Is it possible to add a function to the dropdown list that says 'Edit'. Basically, when the user gets to that point in the form they discover that the item they need from the dropdown list is not there and they want to add it, before going on to the next field on the form. Is there a way to do this in Access (I'm using 2003)

 

[namliam]

You are looking for the "Not in list" event of the combobox....

 

[NotVeryTechie]

Thank you! At least now I know what to look for, didn't know it was called that. When I click on the 'Not in list' I get [Event Procedure], do I need to put code in here? I have never used VBA, so not sure where to start.

 

[namliam]

I think if you search the forum for "not in list event" you will find some samples...
See if you can figure it out from there.

If you have specific questions after having looked at the samples post back here.

 

[boblarson]

This post might help:

http://www.access-programmers.co.uk/forums/showthread.php?t=123921

Also, as far as where code goes, this might help:
http://www.btabdevelopment.com/main/QuickTutorials/Wheretoputcodeforevents/tabid/56/Default.aspx