Trying to populate several fields on a form using an ID entered into a seperate field

[SeanA]

Hello,



I have a database with several different part IDs. Each part ID has a location, status, several work orders, and completetion dates. I am envisioning a form that will have an input box for the part ID. I then would like the remaining fields to autopopulate after an ID has been typed into the input box. I've tried quite a few solutions, to no avail. I am fairly new to access as well, so I aplogize if there is a simple solution I haven't found. Basically, what I am attempting to do is input an ID and have all relevant info for that ID come up.

Any help or tips would be greatly appreciatted.

Thanks,

Sean

[pbaldy]

This type of thing?

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

[SeanA]

That looks like it. I'll try that tomorrow morning at work and let you know. Thanks for the help!

[pbaldy]

No problem, and welcome to the site by the way!

[SeanA]

Worked like a charm! Thanks! (I'll have more quesstions soon, I'm sure)

[pbaldy]

Happy to help!