Results 1 to 2 of 2
  1. #1
    Lois is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2011
    Posts
    15

    Field Data

    Hi,
    how do i get the description field (circled in red) to automatically input the correct info when the Nš is selected from the Nš combo box on the attached doc. i cant upload the database as it is too big...

    thanks

  2. #2
    alansidman's Avatar
    alansidman is offline Indifferent
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,536
    In your query that is used for the No. Box lookup, the columns are numbered from left to right beginning with zero, one, two, etc.

    With your form open in design mode, type directly into the description field
    Code:
    =NoFieldName.Column(x)
    where x is the column containing the description.

    BTW. If you run a compact and repair and then zip your file, you will probably get it under the minimum required size for uploading.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. multiple field data
    By smastersonjr in forum Access
    Replies: 5
    Last Post: 08-19-2011, 02:56 PM
  2. If Field is Null - Then Use Data from Other Field
    By KrenzyRyan in forum Queries
    Replies: 4
    Last Post: 06-10-2011, 12:12 AM
  3. how to export data field to field in a table
    By farhanahmed in forum Database Design
    Replies: 1
    Last Post: 04-05-2011, 10:04 AM
  4. Replies: 3
    Last Post: 11-05-2010, 03:10 PM
  5. Field gets data from Expression?
    By Willot in forum Access
    Replies: 3
    Last Post: 12-10-2005, 06:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums