I have just finished (almost) my first ADO database (connected to an Access database). It's a kind of scientific reference manager. Everything looks OK EXCEPT that :

When I try to add a new record and if some fields remain empty then either
1. I get an error during the Recordset.update process (saying "Invalid use of Null" )
or
2.When I try to review a record with empty fields the text boxes that are assigned to present the Fields data (for example : txtTitle.text=rs.Fields("Title").Value) do not accept the Null values (reasonable!).

Please Help. It may be a stupid problem but I am new in VB and databases.

Thanks

Emmanuel