Adding to Pull down List in Form (1 Viewer)

Fozi

Registered User.
Local time
Today, 05:45
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
 

JANR

Registered User.
Local time
Today, 06:45
Joined
Jan 21, 2009
Messages
1,623
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 (Users: 0, Guests: 1)

Top Bottom