hi Bill,
> Dim fldDateAttended as Field
Declare it also as DAO.Field.
> Set fldDateDone = rs("DateDone")
> I get a data type mismatch when execution gets to the set fldDateDone line.
Avoid default values, cause i think your rs() returns the value of the
field. Try the explicit syntax instead:
Set fldDateDone = rs.Fields.Item("DateDone")
mfG
--> stefan <--
Bill H. - 04 Nov 2006 19:41 GMT
Hm. Not sure what you mean by "returns the value of the field."
That is what I want (I think). I want the values that are in the table with
the field named "DateDone."
> hi Bill,
>
[quoted text clipped - 10 lines]
> mfG
> --> stefan <--
"Field" is an object in both the ADO and DAO models.
Try:
Dim fldDateAttended as DAO.Field
(The list of objects with the same names in the 2 models is Connection,
Error, Errors, Field, Fields, Parameter, Parameters, Property, Properties
and Recordset)

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
> Why doesn't this work?
>
[quoted text clipped - 19 lines]
>
> Thx.
Bill H. - 04 Nov 2006 20:48 GMT
I did try that, but apparently not it all places, for it now works.
Thanks!
> "Field" is an object in both the ADO and DAO models.
>
[quoted text clipped - 5 lines]
> Error, Errors, Field, Fields, Parameter, Parameters, Property, Properties
> and Recordset)