Form Loading

[Guest_imported]

I'm trying to use the following code so that when my form loads in my project the text boxes are updated with information from my database. As far as I can tell, this code is the same as for 3 other forms in my project, which all load perfectly fine, but whatever code I use for this form I get an error. What's wrong?

Option Explicit

Private Sub cmdClose_Click()
Form5.Hide 'when the close button is clicked, hide the form
Unload Form5

Form1.Show 'show form 1
End Sub

Private Sub updateFields()
txtEntitlement.Text = DataEnvironment1.rsHolidaySick.Fields("Entitlement&quot
txtTaken.Text = DataEnvironment1.rsHolidaySick.Fields("Taken&quot
txtRemaining.Text = DataEnvironment1.rsHolidaySick.Fields("Remaining&quot
txtSickEntitlement.Text = DataEnvironment1.rsHolidaySick.Fields("Sick Entitlement&quot
txtSickTaken.Text = DataEnvironment1.rsHolidaySick.Fields("Sick Taken&quot
txtSickRemaining.Text = DataEnvironment1.rsHolidaySick.Fields("Sick Remaining&quot
'update the text boxes with data from the relevant database fields
End Sub

Private Sub Form_Load()
updateFields 'initiate the update fields command when the form loads
End Sub

 

[woyler]

What is the error?