Adding to Pull down List in Form

Fozi

Registered User.
Local time
Today, 10:48
Joined
Feb 28, 2006
Messages
137
Hi

Users identify organisations against a project from a pull down list which pulls from TBL_Organisations.

If the user has an organisation that is not already in the pull down list, can they add to it from the pull-down, thereby adding to the table or do they have to exit the form, add to the TBL_Organisations and then go back in to select?

Thanks
Frank
 
If the user has an organisation that is not already in the pull down list, can they add to it from the pull-down, thereby adding to the table or do they have to exit the form, add to the TBL_Organisations and then go back in to select?

No, what you are looking for is "NotInList" event of your combo. See if this link helps: http://www.fontstuff.com/access/acctut20.htm

JR
 

Users who are viewing this thread

Back
Top Bottom