Access 2013 - Form - drop down menu

[ajboots]

New to Access.

On a form I have a drop down menu (combo box) with the menu choices being pulled from a table. I'd like users to be able to use the drop down selections for the most commonly used entries, but also be able to enter unique data in the field.

Any help appreciated. Thanks, AJ

 

[Micron]

A common method is to use the NotInList method because it gives you the option to cancel the addition of data if the user expects it should already be there. This can happen if a user is allowed to type into the control but a typo results in a value that they think is there but is not. Their entry can be cancelled, or the entry can be added if it passes validation.

https://msdn.microsoft.com/en-us/library/office/ff845736.aspx

 

[ajboots]

thanks - I'll give that a shot