AddNew method does not work
I have the following code in the click event of a save button to add a new
record to a table
Dim dbs as database, rst as recordset
set dbs = opendatabase("c:\....\dbMembers.mdb")
set rst = dbs.openrecordset("MEMBERS")
debug. print rst.updatable 'returns true!!!
rst.Addnew
rst!MemberId = txtMemberId
rst!MembFunction = txtMembFunction
rst!MainFunction = chkMainFunction
rst.Update
rst.close
set dbs = nothing
I get no errors when i click the button, but the record is not added to the
table.
When i step through the code I can see that the textbox values are passed to
the table fields but it seems like the update method has no effect.
Has anyone any suggestions on this problem?
Thanks a lot
Jef
