When selecting a value for one field how do you get other fields to auto populate

[daleachilvers]

I have a form and a user selects the Activity Type. Each activity type has an activity # associated with it. I want the Item # to populate automatically when the Activity Type is chosen. I am pulling this info from another table that stores all the info, which I use as a lookup. Thank you

[alansidman]

Is this what you had in mind?

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

[daleachilvers]

What value do you put in for ComboName?

[alansidman]

That is the name of your combobox control.