Cant remember very well but think goes like this.You first make a recordset which will hold the input
RecordsetName![FieldName] = ControlContents
write a sub UpdateRecord
here u will call the recordset.update method
This will have called another sub that will actually populate the recordset WritetoRecordset using the syntax
RecordsetName![FieldName] = ControlContents (if the text controls then .txt.
sub UpdateRecord
WriteToRecordset
recordset.update
End sub
Sub WriteToRecord
RecordsetName![FieldName] = F_Name.txt
RecordsetName![FieldName] = l_Name.txt
RecordsetName![FieldName] = phone.txt
End sub
This sub will be called from the save button once the form has been populated.
The connection object has to be instantiated and available as that is what the recordset is going to use. The cn obj holds the parameters that will be used to wirte back to the db.
Hope that helps
--
"Humility grows a little more each time i genuinely listen to the experience of another human being". Brahma Kumaris