Using a String to reference a Textbox

[WillC]

I have a recordset and am looping through the records taking field values and would like to display each one in a separate text box in a form, each textbox has a similar name - Textbox1, TextBox2, TextBox3 etc Is there a way of using a string to reference a textbox so i can just change the last digit? Or is there a better method of doing this? thanks for any help

 

[vbaInet]

Bind the form to the table or query.

 

[WillC]

Sorry can you elaborate on that don't really understand....

 

[vbaInet]

Forms are of two folds, bound and unbound. If you use the form wizard and selects a query or table to base it on, the form because bound to that query/table.

I don't see your use of a recordset if you can easily bind the form to a table/query. To bind the form to a source, select one in its Record Source property.

 

[WillC]

Oh I understand not sure if this would be good for my case, the form is based on a table called group (a group of assets), I'm using a query to filter which assets are displayed/can be edited from in the group and the filter is determined by field 'Group Type' (there are three different group types)... its quite complicated, I'll think about trying your method thanks

 

[vbaInet]

Remember you can also set the Record Source to the query too.