I am trying to create text boxes that will fill in when you select a value from a combo box. My Table has five (5) columns (includes the ID column) and on my form I have a combo box that list data that is in the 2nd column and I can get the data to show in one of the text boxes using Me.[TextBoxName1] = Me.ComboID.column(2) but when i type the next Me.[TextBoxName2] = Me.ComboID.column(3) and
Me.[TextBoxName3] = Me.ComboID.column(4) nothing will appear in the TextBoxName2 And TextBoxName3. Any information on how i could get this data to appear in those Text Boxes would be appricated.

---

Answer from Richard Rost:

If you have all of that data in your combo box columns, then what you have there should work OK in the AfterUpdate event for your combo box. If not, I would have to see your database to tell you for sure.

Personally, I prefer using a DLOOKUP statement instead of filling unnecessary data into my combo boxes. It runs faster. See this tutorial:

You can use the DLOOKUP function to look up a specific value from a table or query.

Please see the following FREE video tutorial on my web site for step-by-step instructions on how to use DLOOKUP:

http://599cd.com/tips/access/dlookup-function?key=BlFAlEx