Results 1 to 11 of 11
  1. #1
    BardiyaS is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    7

    Auto-fill a field based on the selection in another field

    Hello everyone,

    I am a novice Access user. Our company is moving a lot of these logs from Excel to Access and I have been learning Access on the fly.

    Just to give you an idea of my skill level, I have gotten the hang of things as far as creating tables, forms, and split databases, and I just google my questions when I get stuck and often end up on this forum. I have yet to find step-by-step instructions on how to perform this "auto-fill" function so your assistance will be greatly appreciated.

    Just as a side-note, I am using Access 2010:

    One of our logs includes the following 4 fields:

    SE (sales executive) | Region | Tier | Sales Channel

    We want to make it so that the "Region", "Tier", and "Sales Channel" fields fill out automatically depending on which "SE" was selected.

    So if I select "Ron Burgundy" from the "SE" field,

    "Region" should auto-fill: West
    "Tier" should auto-fill: 2
    Sales Channel: Inside

    If I select "Marco Polo" from the SE" field,

    "Region" should auto-fill: East
    "Tier" should auto-fill: 2
    Sales Channel: Outside

    And so on.... I am working with only one table, but I am willing to create another table if this action requires multiple tables.

    Please let me know how I can make my request more clear. I am not sure if I am asking this in the right section either.



    Thank you so much!

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

    http://www.baldyweb.com/Autofill.htm

    A table for the selections would be most common, and most dynamic. You could hard code them, but I wouldn't.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    BardiyaS is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    7
    Thank you, this seems like it would work.

    I'll try to follow these instructions tomorrow and I'll update this thread if it works.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No problem, post back if you get stuck. Welcome to the site by the way!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    BardiyaS is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    7
    Thank you again for your assistance pBaldy but I could not do my auto-fill.

    I am as novice to as it gets, I get very confused when playing with "Field Properties" under the "Design" view of a Table.

    When it says "If all you need to do is display the related info on your Orders form" I want these additional fields to show up on the Table and the Form. Ideally, I want to learn how to do this on a Table and then create a Form out of it.

    If I have my 4 fields: SE| Region | Tier | Sales Channel

    I don't know which ones I should use "Lookup Wizard" for, or what I should type once in "Lookup Wizard", I don't know if the modifications to the "Field Properties" should be applied to all 4 fields.

    Please let me know if I can be more specific. Thank you again for your help.

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I would not use that at all:

    http://access.mvps.org/access/lookupfields.htm

    I'd be working at the form level.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    BardiyaS is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    7
    Is there any way to do what I want in a Table though?

    This database is being kept very simple, the employees like the Table view because it is very similar to Excel in the "look and feel".

    Our main reason for moving to Access is the ability to do split databases and that it is easier to search and have multiple users with Access (when compared to Excel).

    We are taking baby steps into fully taking advantage of the features Access offers, but for now we want to primarily do this in a Table.

  8. #8
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I don't let users in tables. You have little to no control over what goes on there. To my knowledge, you can't do what you want in a table.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  9. #9
    BardiyaS is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    7
    Thank you for your help pbaldy.

    I will implement this in a form view and present it to the team as a sample of how it would work. Hopefully they approve.

    Do you have step-by-step instructions? I am reading the link that you provided but I just don't know where to start...

  10. #10
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  11. #11
    BardiyaS is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    7
    Sorry, I am still confused with those instructions... Im thinking of just taking some kind of class to learn all this.

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

Similar Threads

  1. Auto-fill one field from another table
    By tasoper in forum Access
    Replies: 3
    Last Post: 06-13-2014, 07:17 AM
  2. Replies: 3
    Last Post: 10-03-2011, 02:33 PM
  3. Replies: 4
    Last Post: 02-08-2011, 08:43 AM
  4. Replies: 5
    Last Post: 01-20-2011, 11:36 PM
  5. Replies: 2
    Last Post: 09-20-2010, 09:02 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