Hello All Please forgive the novice question; I am just beginning Access VBA, though I have done a fair amount of Word VBA in the past.
I'm using an ADO disconnected recordset derived from a single table. I have a form with an Add New button, and the onClick event fires an AddRecord sub that is basically: Clear the fields on the form rs.AddNew rs.Update If I understand correctly, the first line clears the field, and the second adds a new, blank record to the local recordset. Does the Update method update the blank record with the values on the form (which are blank)? I also have a button that reopens the connection, saves the changes to the database, and closes the connection. Problem: I seem to end up with (i) blank rows in the database, or (ii) an error message saying that the record must have at least one field with a value. Not quite sure what scenario produces each, but I've certainly seen both. Could someone please explain to me how this works? And how I can prevent it happening? I told you it was a dumb question... Thanks. Roger Shuttleworth London, Canada
