In the code txtday& i & k is the dynamically created textbox. I am able to create textbox. But not able to insert data into it. The above statement is working fine.
Expand|Select|Wrap|Line Numbers
- Forms!result!txtday.Value = days
But i am getting error when &i & k are inserted to code. message says
" Compile error:
Expected: = "
I would like to know the syntax for inserting data.
Thanks
Expand|Select|Wrap|Line Numbers
- Public gv_wcnum As String
- Public Function get_schedule()
- Dim days, shifts, total As Integer
- Dim i,k as Integer
- For i = 1 to 20
- For k = 1 to 8
- days = 30/3
- Forms!result!txtday"& i & k".value = days
- next k
- next i
- End Function