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!
  • Students Click Here

*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.

Students Click Here


Linked Table with Multi Value Combo Box

Linked Table with Multi Value Combo Box

Linked Table with Multi Value Combo Box

I have a form with Linked table and one of the fields is a Multi Value Combo Box. The Form only shows one entry from the combo box. However, if I have a local copy of the table I am able to select multiple choices. If there a way to make the multi value on a linked table?

Thank you,


RE: Linked Table with Multi Value Combo Box

What is happening is that a multi value field actually creates a hidden child table, that is how it does the one to many. The link to this table can get lost depending on how you deploy the split db. In the split db delete all linked tables and then relink. You can try just deleting the table with the MV field and relinking, but from what I have read most people need to delete and relink all. If this happens a lot there is code you can find to delete and relink.
You should be able to verify this. On the standalone when you look at a table with the MV field you should see a + sign on those records that will show the subdatasheet. My guess on the split db there will be no subdatasheet.

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!

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