Results 1 to 13 of 13
  1. #1
    taybo93 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2016
    Posts
    8

    Auto-populate data based on an input value

    Hello,

    I need to create an access form that allows me to just enter an ID number from a data set and then auto populated specifications that coincide with the ID number.

    Any help is appreciated, thanks!

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    What exactly is the issue you are having? Tell us about your database, tables and relationships.
    Why do you need to manually input a record ID?

  3. #3
    taybo93 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2016
    Posts
    8
    Field technicians want to enter a Bridge ID number and have all of it's specifications fill in, not search through a list of 200.
    There is one table with many columns, each column being a specification and one being a the bridge ID.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Do these technicians refer to the bridge by Name or ID?
    Many would recommend that you use a combobox (rowsource of BridgeID and BridgeName).
    Let the technician select the BridgeName. Use the iD as a Filter to present all other info about the bridge.

    The combo removes the issue of typos.

    I don't know what knowledge or experience you have with vba, but you might find this free video a source of information.

  5. #5
    taybo93 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2016
    Posts
    8
    They use a ID number in conjunction with DOT. My access experience started last night if that's any indication. My idea is to have a empty box for every spec and only allow input for one box, the ID box. After the input the other data is pulled. Is this possible?

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Possible --yes. But far from ideal, in my view.

    You might want to describe as much as you know about the need for this data and how it all fits together. What do they need this populated form for?

    If you have a table with the ID number and all relevant associated data, then you can use that table to fill a combobox where the technician can select a number or a name. But, we really need more info as to the purpose of filling in that form.

    A few sample records may help also.

  7. #7
    taybo93 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2016
    Posts
    8
    The purpose of this is for field technicians to go on-site, look up the bridge by ID number and get all of the specifications for inspections. There will also be an area to make comment/check off marks later on but I need to get the first part down. I played with the combo boxes for a little but couldn't find a way to say when Bridge ID=this, pull this value from the same row but different column from the datasheet.
    I cant upload the file for some reason, but here's a pic:

    Click image for larger version. 

Name:	Capture.PNG 
Views:	20 
Size:	23.9 KB 
ID:	25303

  8. #8
    taybo93 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2016
    Posts
    8
    Kind of like how google chrome has an autofill if you put your first name in during a registration process

  9. #9
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  10. #10
    taybo93 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2016
    Posts
    8
    I don't want it to be a search, just an autofill given one input value.

  11. #11
    taybo93 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2016
    Posts
    8
    sia.pdf Similar to this format

  12. #12
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    The search was just to show you the concept of using a combobox as a filter.
    You use the combo to hold the ids or names, the user selects one, and the form is populated with the details of that selection

    But, you can certainly have a textbox, let the user type a number ( you might want to do some sort of validation of that entry), then open your form with a record source that includes the value typed into the text box.

    Good luck with your project.

  13. #13
    taybo93 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2016
    Posts
    8
    Quote Originally Posted by orange View Post
    The search was just to show you the concept of using a combobox as a filter.
    You use the combo to hold the ids or names, the user selects one, and the form is populated with the details of that selection

    But, you can certainly have a textbox, let the user type a number ( you might want to do some sort of validation of that entry), then open your form with a record source that includes the value typed into the text box.

    Good luck with your project.

    Thanks for the help! Any resources to show how to do that? I know approximately 1% of this program.

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

Similar Threads

  1. Populate Subreport Controls Based On User Input
    By unifyzero in forum Reports
    Replies: 2
    Last Post: 06-25-2015, 08:42 AM
  2. auto populate based on three entries
    By gbmarlysis in forum Access
    Replies: 3
    Last Post: 02-25-2015, 12:08 PM
  3. Replies: 1
    Last Post: 08-10-2014, 04:06 PM
  4. Replies: 2
    Last Post: 07-07-2014, 09:19 AM
  5. Replies: 3
    Last Post: 08-25-2010, 09:03 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