Table / Query Problem

[Guest]

Hi,
I'm not sure if this is the correct place to post for the problem I'm
having. I already have a db design and it has been working well for quite
some time, until a couple of days ago. A user received a message while in
db, something about copying, he selected yes (sorry for being so vague but I
didn't see the msg or what it related to) and there have been problems ever
since. I do know that the subform for this table had "#Error" in all the
fields. I checked the table and there were two records for the same job
number (linking field). I corrected this, but in queries where this table is
used, I can't enter nor update data. I'm hoping someone can tell me what to
look for that could possibly be causing this problem. Help would very much
be appreciated!!
Phisaw

 

[TC]

You are saying there is a query where before, you could enter or edit
data via that query, but after, you can no longer do that? What happens
when yo actually try to?

Check the SQL of the query to make sure that it is still correct. If
possible, compare it to a backup copy of the database.

Open each of the tables involved in the query. Scroll through the
datasheets of those tables, looking for signs of data corruption.

Not sure what else to suggest!

HTH,
TC (MVP Access)
http://tc2.atspace.com