Clear a form text box when user changes records

[Artist.Anon]

I have a text box (txtProductInfoBox) on my Products form (fProducts) that gets populated with different product information depending on which command button the user presses.



I display the information requested with VBA code successfully, e.g.

Private Sub ProdInfo_1_Click()

prodinfo = "xxxxxxxxxxxxxxxxxxxxxxx" & "yyyyyyyyyyyyyyyyy" & "zzzzzzzzzzzzzzzzzzzzzz"
Me.txtProductInfoBox.Value = prodinfo

End Sub

The problem comes when the user changes records using the navigation bar or PgUp/PgDn, I need to clear the text box. How do I do this? I have tried form initialization, on change events, but either that is not the solution or I am doing it wrong. All suggestions welcomed.

[June7]

Why do you need to display this concatenated data? This textbox is not bound to a field? Why not just have the expression in textbox ControlSource?

[Artist.Anon]

That was just an example, the actual code does include field values. I have one text box to display three different sets of information depending on which command button the user clicks. All I need is to clear this text box when the user changes records.

[John_G]

Hi -

Try clearing the unbound textboxes in the On Current form event. They will be cleared as soon as you move to another record.

John

[Artist.Anon]

Ah, that was it. Thanks!