View Full Version : Updating Records on a Form


Nocal
03-04-2002, 06:17 AM
I'm simply trying to do the following and am failing miserably.

I have a form showing one record at a time. I want to be a able to press a button which will change a value in a field and save the record.

Is it not possible to reference the recordset of the Form ?? I have tried everything. I can get the the current record number, the recordsource name i.e. the table name but I cannot reference the actual recordset for the form.

What I have tried is:
Dim rs As Object

rs = Me.Recordset.Clone
rs = Form!Test.recordset
re = Me.Recordset

I need to update the recordset but how can I do that without being able to reference it??

Any help would be greatly appreciated !!

chrismcbride
03-04-2002, 08:32 AM
You don't need to use the Recordset object to make changes to the current record. If the value you want to change has a bound control on the form then you can use code to place the value in it. If not, just add one and make it invisible (if you want).
Chris