Populate text boxes from combo box selections and correct entries on navigation

[jambraun]

Hello, I happened on this forum by chance and already found answers to many things I was looking for but I'm stumped now



I created a form to populate personnel information and instead of typing items out many times I'm using seperate tables to store the more static information. The idea is to use a combo box and based on the answer display values from the collumns in adjacent text boxes. Using an 'After Update' event, the text boxes populate just fine when I select the entry from the drop down box:

 
Private Sub Desk_AfterUpdate()
Me!RoomLook = Me!Desk.Column(1)
Me!JackLook = Me!Desk.Column(2)
Me!PhoneLook = Me!Desk.Column(3)
End Sub

Now here's the problem. When changing records, going to next record / prvious record / new record, the values in those text boxes appear to be set to whatever was stored at the last combo selection. When reloading the form, the boxes are empty instead of displaying values from the combo selection.

I know the answer is simple but it's escaped me for the past day with many attempts. Is there alternative code that I can use to populate these text boxes each time the form is opened, a different record is navigated to / a record is deleted / new record created?

Thanks so much for your assistance!

[pbaldy]

You would need the same code in the Current event. An alternative would be to have textbox control sources like:

=Desk.Column(1)

[jambraun]

Pbaldy, you ROCK!

I knew it was something simple. I didn't understand the meaning of control sources until you posted that. Looks like that did the trick. Thanks!

[pbaldy]

Happy to help, and welcome to the site!

The code solution would only be necessary if for some reason you had to save the values to a table. For display only, the other method is simpler.