Editing a specific textbox depending on a number

[adamk1906]

Hi,

Essentially I want to edit a specific textbox depending on a number which is dependent on a number of things and varies each time the form is run.

For example, if the number is 0 I want to edit tb0.value. If it's 1 I want to edit tb1.value etc. I have specifically labelled my text boxes in this way.


I thought something like this would work

textBoxName = "tb" & number
textBoxName.value = "this is the value I want to enter".

However, this does not work and it produces an error saying 'Invalid Qualifier'.

Please help.

Thanks

[pbaldy]

Try

Me("tb" & number) = your value

[adamk]

Perfect Thanks

[pbaldy]

No problemo. Welcome to the site by the way!