Results 1 to 4 of 4

Fields populate based on another field

  1. #1
    jlclark4 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Dec 2010
    Location
    North Carolina
    Posts
    155

    Fields populate based on another field

    I have a form with several different fields.

    I have a table with a list of numbers. (Lets say 1-10). Each number has a
    corresponding date and type. (tblDailyClaimDate)
    I also have a table with the 5 fields listed below. (tblData)

    Number (Number)
    Date (Date/Time)
    Type (Text)
    Name (Text)
    New (Yes/No)

    The form contains the 5 fields above.

    I want to be able type in the number and have the date and type auto populate based on the table tblDailyClaimDate and then I fill in the rest of the fields and it write to tblDate.

    Is this possible?

    I have worked with Combo Boxs populating lists based on another combo box, but not something like this. I am not sure if it works the same way...

    Thanks!

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    12,206
    Is this what you're after?

    BaldyWeb - Autofill
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  3. #3
    jlclark4 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Dec 2010
    Location
    North Carolina
    Posts
    155
    Does this still work if the Number field is just a text box not a combo box? There doesn't always have to have information populate in the Date and Type field...

    They also wouldnt be selected the number from a list, they would type in the number.

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    12,206
    No, that method uses the columns of the combo box. You can still use a combo, as the user can type in a number as well as select one.

    If you want to use a textbox, you'd have to use DLookup or open a recordset on the table to get the related values. Since you want more than one value, the recordset would be more efficient.
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 3
    Last Post: 10-03-2011, 01:33 PM
  2. Populate a field based on combobox selection
    By rscott7706 in forum Access
    Replies: 5
    Last Post: 06-02-2011, 02:18 PM
  3. Replies: 2
    Last Post: 12-07-2010, 10:32 AM
  4. Populate one field based upon another fields data
    By BigBrownBear in forum Queries
    Replies: 1
    Last Post: 03-23-2010, 03:27 PM
  5. Replies: 3
    Last Post: 10-05-2009, 06:22 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
  •  
Tech Forums: Microsoft Office Forums