I am using disconnected datasets in an appliation, stored with an ADODB recordset into an .MDB database (MS Jet).

For testing, I add a new record, only partially filled out. No problem.

BUT when I retreive the record, and try to load it into the components on my form (text boxes, combo boxes, etc), the fields which I left blank won't load. The error message is "Invalid use of null", which happens regardless of the data type. Even if I try to convert the field into a sting (Cstr()), I get the same message.

How can I prevent this?