Adding Records into SQL db

  • Thread starter Thread starter Craig
  • Start date Start date
C

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
 
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".
Click to expand...
Check your PK on the server, compare it with th PK in the linked table.
Optionally add a timestamp field.

mfG
--> stefan <--
 
Back
Top