INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

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

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

(OP)
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

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

(OP)
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"

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

If the field is name Problem, don't use Problems

I would try:

CODE --> vba

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

Duane
Hook'D on Access
MS Access MVP

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close