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!
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!
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?
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.
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.
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?
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.
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:
Kind of like how google chrome has an autofill if you put your first name in during a registration process
Did you look at the free video I mentioned? Thoughts?
I don't want it to be a search, just an autofill given one input value.
sia.pdf Similar to this format
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.
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.