Auto-populate fields

[justinfromcanada]

This is probably a basic question for of you but here goes.

I have a number of tables in my database, and they're linked in with a form. I'd like to have a field in a form that's populated automatically based on what's inputted in a different field.

For example, I've got one table with names and descriptions on widgets (name in column A, description in column B).

Widget 1 This widget is blue
Widget 2 This widget is green
Widget 3 This widget is yellow

When I'm in my form, I want when I select Widget 1 to have the corresponding text (This widget is blue) appear in a field below.

What's the easiest way to do this? Help much appreciated

 

[pbaldy]

How about

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

 

[justinfromcanada]

Thanks! Looks straightforward enough. I've followed the steps and the result it gives me in my text box is #Name?

 

[pbaldy]

Did you use the name of your combo in place of "ComboName"?

 

[justinfromcanada]

Yes, I've done that. I made the combo box, then the text box... If I just put in the name of the combo box in the control source, it gives me the first column of the combo box. As soon as I add .Column(2) (I've also tried substituting that with the name of the column header) it stops working.

 

[pbaldy]

If you want the second column of the combo, try Column(1) as the column property is zero based.