Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 342
  • Last Modified:

Form fields show "#Deleted" after inserting new record

I have an Access 2002 front end pointing to SQL Server 2000.

On one continuous form I have, I have a problem when I add a new record and save it by moving to the next one. What happens is that all the fields in the newly added recordchange to "#DELETED"!

If I close the form and open it, the records are there!

0
BigJ
Asked:
BigJ
  • 3
  • 2
1 Solution
 
arbertCommented:
have you tried the REQUERY event after the save?
0
 
BigJAuthor Commented:
It turned out to be a bug in Access that relates to indexing in SQL Server...
0
 
arbertCommented:
Please close the question....
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
BigJAuthor Commented:
not sure how, there's no 'close' button... There used to be, a long time ago.
0
 
arbertCommented:
Post a "question" in CS with a link to this question and ask to delete/refund....
0
 
ee_ai_constructCommented:
Closed, 400 points refunded.
ee_ai_construct
Community Support Moderator
(re-order part number xm34)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now