Reply to Message

Something that I read when I started with access which has stood me in good stead.

Never unless it REALLY does not matter leave labels and controls with their default names such as Combo 17 or text 6.

What is Combo 17 or text 12?

rename your controls with a name that identifies the contol such as cmbNameLookUp. and Text 12 as txtFirstName

When you have dozens of controls it makes all the difference and if someone has to come after you and tweak your VBA they will bless you rather than curse you.

Cheers - Alan