I have VBA code that reads each table in an access database. It parses the table names and computes a total for a integer field in each table. It does this in a for each tbl in tbldef. As the total is developed I want to display this in a text box in a single Access form. The name of the text box is in the form of a variable. There are over 200 text boxes to update. The vba code works properly until I try to update the text box.
If the I have a strName="Forms.frmTotalBirdCount"+strTextBoxName. How do I make something like strName=intTotal
The Form is current. I have tried several approaches and I am looking for advice on the the best or better way.
Thank you,
Jerry