Combo boxes

  • Thread starter Thread starter snelson via AccessMonster.com
  • Start date Start date
S

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
 
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
 
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.
Click to expand...
[quoted text clipped - 21 lines]
Steve
Click to expand...
Click to expand...
 
you're welcome....that's what we're here for. :)


snelson via AccessMonster.com said:
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.
Click to expand...
[quoted text clipped - 21 lines]
Steve
Click to expand...
Click to expand...
Click to expand...
 
Back
Top