adding new value via combo box?

[gussy]

Perhaps a silly question, but it's something I've encountered before and never really managed to do....

I want a drop down combo box that looks up data in a table. Selecting the desired value, then lets the rest of the form display all the other related fields to that value. That's fine, no problemo. But if, in that combo box field, I want to add a new one that isn't listed in the box....how on earth can I do that?

Obviously just typing it in gives an error message.

Any suggestions?

Thanks in anticipation.

 

[dcx693]

There are numerous posts in the forums on adding data to combo boxes. Try searching. Here's another good article: Add item to combo box using OnNotinList event.