Refresh a specific subform

[YollemCrumble]

I am trying to create a digital board with configuable columns, if the columns are too long, I want to scroll them one at a time and refresh that column. Each column is displayed in its own sub-form. I have a table with various information about the column including the subform name (or what I believe is the subform name) as a string. I can refresh the form and all subforms, but I want to only refresh the subform which has changed due to a scroll of the data
The trial code I have is :

Dim frmname As String
 Dim dbdatabase2 As DAO.Database
 Set dbdatabase2 = CurrentDb
 Set rs = dbdatabase2.OpenRecordset("BoardInfo")
 Do While bigcnt < 3 'while in test mode just do three loops
 rs.MoveFirst
 Do While Not rs.EOF
   If rs("datalen").Value < rs("collen").Value Then GoTo notneeded ' ie if no need to scroll skip the nxt bit
   Cnt = ScrollData(rs("TableData").Value, rs("Subformdata").Value, rs("Collen").Value, rs("begin").Value) 
    'my scroll routine which updates the column data returns the record number of the first record in the column
   rs.Edit
   rs("begin").Value = Cnt 'keep a track of the start of the scroll
   rs.Update
   frmname = rs("Subformname").Value 'get the subform name from the table
   Forms!HonourBoard.mychildformname.Form(frmname).Refresh  'refresh the specific subform (this causes an error)
   Pause (5)
notneeded:
   rs.MoveNext
 Loop

I am sure the issue is just one of syntax, so if anyone can assist I would be very greatful.

[NeoPa]

Hi there. Welcome to Bytes.com.

Let me start with a quick link to an article that explains subform referencing (Referring to Items on a Sub-Form).

Hopefully from there you can adjust your own code. It looks like you're pretty close already TBF. If not then let us know & we'll go into it more closely for you.

You don't show the header or footer of the subroutine so we're missing vital information, but if the code is in the module of the main form then you can replace some of the reference with the Me keyword. I expect changes are required for line #15.