I got a doubt as follows:
No matter it is using ADDNEW or EDIT in recordset, values are assigned to different fields but before doing the UPDATE action, if I assigned those fields to another variables. Those fields content would also be assigned to those variable or only can those fields got values after the UPDATE action!??
FOR INSTANCE, T1 or T2 will got the same result as TRANS1![NAME] and TRANS1![QTY] ??
Dim TRANS1 As Dao.Recordset
Set TRANS1 = CurrentDb.OpenRecordset("select * " & " from MASTER order by INVOICENUM, dbOpenDynaset)
Dim T1 As STRING
DIM T2 as SINGLE
TRANS1.ADDNEW
TRANS1![NAME] = me.NAME
TRANS1![QTY] = ME.HIGH * ME.LENGTH
T1 = TRANS1![NAME]
T2 = TRANS1![QTY]
TRANS1.UPDATE
:
:
:
No matter it is using ADDNEW or EDIT in recordset, values are assigned to different fields but before doing the UPDATE action, if I assigned those fields to another variables. Those fields content would also be assigned to those variable or only can those fields got values after the UPDATE action!??
FOR INSTANCE, T1 or T2 will got the same result as TRANS1![NAME] and TRANS1![QTY] ??
Dim TRANS1 As Dao.Recordset
Set TRANS1 = CurrentDb.OpenRecordset("select * " & " from MASTER order by INVOICENUM, dbOpenDynaset)
Dim T1 As STRING
DIM T2 as SINGLE
TRANS1.ADDNEW
TRANS1![NAME] = me.NAME
TRANS1![QTY] = ME.HIGH * ME.LENGTH
T1 = TRANS1![NAME]
T2 = TRANS1![QTY]
TRANS1.UPDATE
:
:
: