Adding an Item to a Drop Down List "Add New Problem"

[markcrobinson]

It's a call recording database.
CALLS db is one record per call
A drop down "Problem" links to database PROBLEMS
On the call form, user will click the drop down and select from a common problem.

I would like an "Add New" Selection at the top of the list which will cause a new record to be added to the PROBLEMS database.

The challenge is that I need it to be really simple - it's being filled in while the CSR is on the phone. Select the "Add New" item, type in in, and move on.

Can you point me in the right direction?


Thank you,
Mark Robinson

 

[jedraw]

see the choices here

http://allenbrowne.com/ser-27.html

 

[markcrobinson]

Thank you,
Can you tell me why this statement isn't working per the code referenced?

INSERT INTO WCProbs (Problems) SELECT "addthis3" AS Problem;

DB Name is WCProbs, Field is named "Problem"

 

[dhookom]

If the field is name Problem, don't use Problem[highlight #FCE94F]s[/highlight]

I would try:

INSERT INTO WCProbs (Problem) VALUES ( "addthis3")

Duane
Hook'D on Access
MS Access MVP