Combo boxes

[snelson via AccessMonster.com]

I have been reading previous posts for some time and I find myself getting
deeper and deeper.

My problem is this. I have a form with a combo box (using a look up table) I
keep the unique ID number from the look up table in my main table. I want to
populate two unbound text fields to show the value of columns in the combo
box. I have acheived this BUT as soon as I close the form and then reopen it
the information is not displayed in the unbound text fields.

I have used the AfterUpdate and put this in it

Private Sub Combo578_AfterUpdate()
If IsNull(Me.Combo578) Then
Exit Sub
End If
Me.Short1 = Me.Combo578.Column(1)
Me.FullOffence = Me.Combo578.Column(2)
End Sub

How do I get the two unbound text fields to show the information that relates
to information being shown in the combo box?

thanks in advance, any help would be appreciated

Steve

 

[tina]

you don't need code to do this. just set the ControlSource of the unbound
textbox controls, as

=[Combo578].[Column](1)
=[Combo578].[Column](2)

hth

 

[snelson via AccessMonster.com]

Well imagine that...how simple, I have been trying for days, reading all the
posts and even posting on other sites. But to no avail (maybe it was my way
of communicating the problem)

You have been of great assistance to me, quick and to the point.

thank you, I will be using this site more often.

Steve

you don't need code to do this. just set the ControlSource of the unbound
textbox controls, as

=[Combo578].[Column](1)
=[Combo578].[Column](2)

hth

I have been reading previous posts for some time and I find myself getting
deeper and deeper.

[quoted text clipped - 21 lines]

Steve

 

[tina]

you're welcome....that's what we're here for.

Well imagine that...how simple, I have been trying for days, reading all the
posts and even posting on other sites. But to no avail (maybe it was my way
of communicating the problem)

You have been of great assistance to me, quick and to the point.

thank you, I will be using this site more often.

Steve

you don't need code to do this. just set the ControlSource of the unbound
textbox controls, as

=[Combo578].[Column](1)
=[Combo578].[Column](2)

hth

I have been reading previous posts for some time and I find myself getting
deeper and deeper.

[quoted text clipped - 21 lines]

Steve