G
Guest
Hello, I'm developing a program that will include a window showing current &
previous records using a scrollable recordset. I need to add records to the
recordset & have new records immediately available in the current record.
What is the most common way of adding new records. Is it:
i) by adding records via the same form & hence using the same recordset?
(This seems the simplest way as you can keep the scope of the data object
local to the form, but might look a bit messy) or:
ii) Create an input form which opens to accept new record details, then
updates the underlying table. (This would seem trickier as you would need to
declare the scope of the data object global, (something I don't want to do),
or preferably to refresh the recordset on the first form through an event,
such as getfocus or paint, once the input form has been unloaded? ).
In short, what is the most acceptible method for data input to a dynamic
recordset?
Thanks for your thoughts on this, Ant
previous records using a scrollable recordset. I need to add records to the
recordset & have new records immediately available in the current record.
What is the most common way of adding new records. Is it:
i) by adding records via the same form & hence using the same recordset?
(This seems the simplest way as you can keep the scope of the data object
local to the form, but might look a bit messy) or:
ii) Create an input form which opens to accept new record details, then
updates the underlying table. (This would seem trickier as you would need to
declare the scope of the data object global, (something I don't want to do),
or preferably to refresh the recordset on the first form through an event,
such as getfocus or paint, once the input form has been unloaded? ).
In short, what is the most acceptible method for data input to a dynamic
recordset?
Thanks for your thoughts on this, Ant