Combo box help please!

[rixter67]

I have a form that contains 1 combo box and 2 unbound text fields. My question is with the following code, I get the text fields to fill based on the combo box selection, but the text fields are the same as I scroll through the records.

How do I get the text fields to stay and update the table for each particular record.

Any help is greatly appreciated.

Here is the code for the combo box:
Private Sub Agency_AfterUpdate()
Me.tmpid.Value = Me.Agency.Column(1)
Me.tmploc.Value = Me.Agency.Column(2)
DoCmd.Requery "tmpid"
DoCmd.Requery "tmploc"
End Sub

 

[Crowley16]

if you want the text fields to automatically update the underlying record, then you would have to bound them to the field/record they intend to change.

you can still you the combobox to automatically set the value of the text boxes, just as in your code...

--------------------
Procrastinate Now!

 

[TheAceMan1]

How are ya rixter67 . . . . .

This is typical behavior for an [blue]unbound control[/blue] in the [blue]Detail Section[/blue] of a [blue]continuous form.[/blue]

[purple]The textboxes need to be bound![/purple]

See Ya! . . . . . .

 

[rixter67]

Thanks for the replies. After I thought about it, I used the temp fields as holders and bound the two text boxes. It appears to be working now. Thanks again.