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

combo box question

combo box question

(OP)
how would I let a customer update using allow value list edits, a combo box with 2 columns?
I can do it fine with one but with 2 it only updates the first column.

CODE

cboMtrReason
Rowsource:  
SELECT tblMeterTestReasonType.MeterTestREason, tblMeterTestReasonType.ReasonDesc
FROM tblMeterTestReasonType;

Rowsource Type:  Table/Query
Bound to:  column 1
Allow value list edits: yes
Limit to list :  no 

Data Sample
MeterTestREason          ReasonDesc 
088                           PM 
11                            NR 
014                           Special test 
010                           CFD 
017                          Other 
099                          New 

so when they add a new one, I need them to put the number and description

thanks
lhuffst

RE: combo box question

Perhaps set this up as a table rather than a value list, maybe have user enter the number and reason like this: 088;PM
Then use vba and split function to append them to there respective fields. Or you could set up the not in list event to open a popup form and have to separate text boxes for the fields.

RE: combo box question

I would give them a feature to allow them to add to the table. I usually put an icon next to my updateable comboboxes. I almost never allow value list edits and almost always limit to list. If you click the "add/edit" icon it pops open a dialog form where you can add/edit the values. This way you can do lots of data verification and only save the record if both fields are populated.

RE: combo box question

(OP)
Sxschech - great idea. I'll try that next time but this time, I ended up going with MajP because there were multiple combos that could need new additions.
I ended up making a new form (maint) and have buttons on that page that brings up a form to allow additions to the table. This way, it I can also control who has access if the customer requests it.
Thanks again Everyone!

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