Adding Records into SQL db

[Craig]

I have a form which I use to display records which are linked to a SQL table
via ODBC. When we add a new record to the table using this form and then
advance to the next record, when we go back to the previous record (the
newly added one) every field shows as "deleted". The only way to show the
record is to close the form and re-open.

This is probably a simple explaination, but ....

TIA

Craig

 

[stefan hoffmann]

hi Craig,

I have a form which I use to display records which are linked to a SQL table
via ODBC. When we add a new record to the table using this form and then
advance to the next record, when we go back to the previous record (the
newly added one) every field shows as "deleted".

Check your PK on the server, compare it with th PK in the linked table.
Optionally add a timestamp field.

mfG
--> stefan <--