How do I change a text box value in datasheet view for only one row? 1

[CGSB]

I have a sub form which opens in datasheet view.

When the user updates a value in one of the rows, I want another value in the same row to grab value from a text box on the parent form.

Currently I have this

Private Sub Status_AfterUpdate()
  txtFileNo = Parent!txtFileNo
End Sub

But this updates the txtFileNo value in every row. I just need to change the value in the row that is currently being worked on. Not all of them!

 

[TheAceMan1]

How are ya CGSB . . .

Apparently [blue]txtFileNo[/blue] is an unbound textbox. This is typical behavior of [blue]unbound[/blue] controls ! . . .

See Ya! . . . . . .

 

[CGSB]

That was the problem! Thanks!