when does a form retrieve records?

[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

 

[Rick Brandt]

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

That often means that the Primary Key of the linked table is a DataType that
doesn't map directly to an Access type. In that situation there can be a
rounding difference betweent the actual value saved and the value interpretted
by Access and the form literally loses track of the record.

If you are ion a position to change the table design it is better to avoid such
types in the Primary Key and if this is a SQL Server table it is also a good
idea to add a Timestamp column which also helps when doing updates.