Results 1 to 2 of 2
  1. 08-25-2010, 12:37 AM #1
    ydt
    ydt is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    1

    Multivalued fields

    Hi!


    Hoping someone can help me!!
    On a form I want to create a multivalued list, which will enable the user to choose a list of job roles, no problem. However, I want a second column on the multivalued list that is editable to specify how many of the job role is required. This editable column will be different for each project/form.

    Currently I have 2 tables, one with the jobs and one for the project. Can someone PLEASE help???!!

    Please also let me know if I'm unclear...
    Reply With Quote Reply With Quote
  2. 08-25-2010, 01:52 PM #2
    NTC
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    well you wouldn't get this done in a second column of a multivalue list....you would use a separate field for this editable information.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. VBA to update matching fields from one table and set unmatching fields to null
    By KP_SoCal in forum Programming
    Replies: 5
    Last Post: 03-20-2010, 08:30 AM
  2. Lookup Wizard and Multivalued columns
    By haygun in forum Access
    Replies: 0
    Last Post: 01-27-2010, 11:04 AM
  3. Group report by a multivalued lookup field
    By jonsons in forum Reports
    Replies: 0
    Last Post: 12-01-2009, 04:08 PM
  4. Table fields which depend on other fields
    By Ben in forum Access
    Replies: 3
    Last Post: 08-10-2009, 08:33 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums