Adding to Pull down List in Form (1 Viewer)

[Fozi]

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]

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