As the user inputs the 'new' data by whatever means, you will need to write some lines of code which are as follows. open the relevant table, or part-table using Dynaset as your Recordset.(Any other type of recordset will not allow updates) then let's say you've called it MyDynaset. You need to code --- MyDynaset.Edit, MyDynaset!Name = txtName.Text, MyDynaset!************ = txtSex.Text etc. (Obviously I don't know the names of the fields in your tables, nor the 'objects' you take your input from, so I use these as an example) then, when all the relevant fields have been updated, MyDynaset.Update. I hope this helps.Liam.
|