Page Controls (I have not used in Access)

D

David Mc

Becuase i have a lot of controls on a page i have had to
tranfer information to a set of page controls. the probelm
is that now i cannot chnage them using VBA as they can not
be found.

How can i access controls within a page control.

David

If txtStudent_ID.Value <> "" Then
If SearchForStudentID(txtStudent_ID.Value, 1, 1) =
9801 Then
txtStartIT_Enrol.Value = ""
txtStartIT_Est_Finish.Value = ""
chkStartIT_M.Value = False
chkStartIT_Tu.Value = False
chkStartIT_W.Value = False
chkStartIT_Th.Value = False
chkStartIT_F.Value = False
chkStartIT_S.Value = False
txtStartIT_Attendance.Value = ""
txtStartIT_Exit_Date.Value = ""
Else
txtStartIT_Enrol.Value = SearchForStudentID
(txtStudent_ID.Value, 1, 1)
txtStartIT_Est_Finish.Value =
SearchForStudentID(txtStudent_ID.Value, 2, 1)
chkStartIT_M.Value = SearchForStudentID
(txtStudent_ID.Value, 3, 1)
chkStartIT_Tu.Value = SearchForStudentID
(txtStudent_ID.Value, 4, 1)
chkStartIT_W.Value = SearchForStudentID
(txtStudent_ID.Value, 5, 1)
chkStartIT_Th.Value = SearchForStudentID
(txtStudent_ID.Value, 6, 1)
chkStartIT_F.Value = SearchForStudentID
(txtStudent_ID.Value, 7, 1)
chkStartIT_S.Value = SearchForStudentID
(txtStudent_ID.Value, 8, 1)
txtStartIT_Attendance.Value =
SearchForStudentID(txtStudent_ID.Value, 9, 1)
txtStartIT_Exit_Date.Value = SearchForStudentID
(txtStudent_ID.Value, 10, 1)
End If
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top