E
everymn
Could anyone tell me when a form is meant to retrieve records from an
ODBC linked datasource? When I insert a record into a form linked to
a local table, and then move back one record, and return, the new
record is still there. If I do this same thing with a form linked to
an ODBC table, then when I return to the new record all of the fields
say "DELETED". However the data is present in the table, and if I
close and reopen the form, then that record will be viewable.
When a form uses an ODBC table as its source, does it only create a
record set once at form open? Is there any way to force it to do it
more often?
Thank You
ODBC linked datasource? When I insert a record into a form linked to
a local table, and then move back one record, and return, the new
record is still there. If I do this same thing with a form linked to
an ODBC table, then when I return to the new record all of the fields
say "DELETED". However the data is present in the table, and if I
close and reopen the form, then that record will be viewable.
When a form uses an ODBC table as its source, does it only create a
record set once at form open? Is there any way to force it to do it
more often?
Thank You