Ok see this code here:

recEnrolment.Open sSQLStm, gconDatabase

Is that missing something?
Or is that it?

If so ado is setting the defaults!
Which i do believe is the problem.

b