Results 1 to 7 of 7
  1. #1
    jroy is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2019
    Posts
    3

    Exclamation Auto fill multiple forms based on single entry in one form

    I have been working on a data base for months now. It will serve the purpose of an HRIS. I am not trained in Access and have been "learning as I go". I am not a programmer and do not understand code but can duplicate what someone else does by watching video. I nearly have everything completed and close to being able to use my database.
    I have made great progress with my database, but I am stuck.
    I have a table “Personal Information” which contains the EmployeeID (not an auto number) which is the Primary Key for the table.
    I have created a form to use for data entry into the table.


    I have created multiple other forms based on other tables of information.
    The foreign key for the other forms is EmployeeID. I have created the relationships.
    The other forms have an EmployeeID field, Last Name field, and First Name field based off of the Personal Information table.
    I have created navigational forms which group certain forms together.
    I have a main form to access the different navigational forms.
    Upon log in, it takes you to the Main Form. From there you can access 4 different navigational forms.
    When entering a new hire, I select Personnel Navigation and the first form opens to a new record.
    I would like to be able to enter the Employee ID and First and Last Name into the first form and it automatically populate all the other forms labels of the same type.
    Can you help me with this? I’ve tried everything I know but I can’t get it to work.

    Thank you-

    At this point, if I could find someone to get onto a web conference call where I could share my screen (I have this tool), I would be willing to pay for help. I really need this database.

  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
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Is this a Navigation Form or a normal form with Tab control?

    Can attach files to post. Following instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    jroy is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2019
    Posts
    3

    Reply to June

    June, I created normal forms. I did create navigation forms which are comprised of my regular forms.

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

  6. #6
    jroy is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2019
    Posts
    3
    Quote Originally Posted by pbaldy View Post
    I will look at again, but I didn't understand it when I looked yesterday. I am less than a novice when it comes to Access.

  7. #7
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Nature of Navigation Form is that only one form is loaded at a time. This makes data entry of related records for master/dependent tables nearly impossible. Use a normal form/subform arrangement.

    LastName and FirstName should not be repeated into multiple tables - this is duplication of data.

    Suggest you attach your db for analysis.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 3
    Last Post: 02-17-2019, 08:54 PM
  2. Replies: 9
    Last Post: 03-01-2017, 10:00 AM
  3. Replies: 9
    Last Post: 02-04-2015, 03:35 PM
  4. Replies: 6
    Last Post: 07-12-2013, 01:07 AM
  5. Multiple Auto Fill in Form
    By mwebster in forum Forms
    Replies: 1
    Last Post: 07-06-2011, 10:39 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
  •  
Other Forums: Microsoft Office Forums