A
Adam
Hi,
I've got a main form [MainForm] and a subform
[subfrmMainForm] bound to it via master/child links.
When the subform returns records in a datasheet showing
records that relate to the main form, do I call those
returned records a recordset?
If that's right, then I want to click a button (either on
the main form or the continous form in subform) to change
or enter a variable in a cell in the recordset.
Say we have returned 5 records, with 4 columns in the
subform. I want to be able to find the value in cell
[record 3, column 2] and increment it by 1(using command
button to calculate) and place the new value in cell
[record 4, column 2]. Only that cell that is to be
changed.
In other words I am asking Access to lookup the last value
in the retrieved records, and increment the value and
place in in the next record, once a button is clicked.
I've been trying to get DLookup or DLast working but to no
avail.
How do I do this may I ask
Many thanks for help
Adam
I've got a main form [MainForm] and a subform
[subfrmMainForm] bound to it via master/child links.
When the subform returns records in a datasheet showing
records that relate to the main form, do I call those
returned records a recordset?
If that's right, then I want to click a button (either on
the main form or the continous form in subform) to change
or enter a variable in a cell in the recordset.
Say we have returned 5 records, with 4 columns in the
subform. I want to be able to find the value in cell
[record 3, column 2] and increment it by 1(using command
button to calculate) and place the new value in cell
[record 4, column 2]. Only that cell that is to be
changed.
In other words I am asking Access to lookup the last value
in the retrieved records, and increment the value and
place in in the next record, once a button is clicked.
I've been trying to get DLookup or DLast working but to no
avail.
How do I do this may I ask
Many thanks for help
Adam