Store 3rd field of a query in a text box

[eddy]

I need to set a value of a text box to the 3rd field of a query when I click a command button in the form. It'll run the query, extract the 3rd field and show it in the text box. Can anyone show me a snippet of code that would do it or something similar?

 

[Simon_MT]

Try:

.[MyTextBox] = .[MyCombi].Column

Simon

 

[eddy]

Didn't work

 

[Simon_MT]

I use VB so try:

AfterUpdate on combi

Forms![MyForm]![MyTextBox] =Forms![MyForm]![MyCombi].Column(2)

or in Control Source of MyTextBox =Forms![MyForm]![MyCombi].Column(2)

Simon