Auto populated text box from combo box value

[GIRLnSD]

I have a form for 2800 different records. I want to auto populate 4 text boxes based on the value of 1 combo box but when I change the data on 1 form, all the forms show the same data. I want to be able to able to change the data on each form and save separately.

I have Table with Tech Initials(PK), Full Name(689), CellNum(691), TestGaugeSN(630) and Cal Exp Date(632). Want to use Tech Initials to populate the rest.

Here's what I'm using:

Private Sub Combo687_AfterUpdate()
Me.Text689 = Me.Combo687.Column(1)
Me.Text691 = Me.Combo687.Column(2)
Me.Text630 = Me.Combo687.Column(3)
Me.Text635 = Me.Combo687.Column(4)
End Sub

Thank you

 

[John Big Booty]

It sounds as if you are using a continuous form, and have just inadvertently discovered on of their little quirks. That being that all derived fields will reflect the values held in record that currently holds focus.

The attached sample demonstrates one method of getting around this, by populating your continuous form with a query. Which is inturn populated using a popup form.