Currently I've got it all as:

Private Sub cmdClear_Click()
firstname.Value = Null
surname.Value = Null
address.Value = Null
town.Value = Null
county.Value = Null
postcode.Value = Null
email.Value = Null
phone.Value = Null
End Sub


However, this clears only one box  when I press the clear  box, and then
the next one down when I click it again. I'm guessing I need some sort
of Loop, how do I implement it?