BTY Forgot to say that IMHO it would be better to add the following line of code to ALL modules (General and Form)
Option Explicit
after the first line so you have:
Option Compare Database
Option Explicit
at the top of each module
BTY Forgot to say that IMHO it would be better to add the following line of code to ALL modules (General and Form)
Option Explicit
after the first line so you have:
Option Compare Database
Option Explicit
at the top of each module
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick