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 !!
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 !!