Search key not found

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My multi-user database has a subform with in a form. The subform is actually
a continuous form. Some end-users seem to get the "invalid argument" error
when they enter data. This does not happen at all times. They push okay to
the error and it keeps popping up. The continuous form contains the below
information.

Enter Date: pulls today's date
Reason: Pull down field (pulls from table)
Memo Field: memo field
Admission Date: Date field
Level of Care: Pull down field (pulls from a list of three subjects)
Reminder Note: Memo field
Reminder Date: Date field

I then try to go to the actual tables and delete the information and it will
not let me. Instead of a member number, it lists a square with a "@". When
I try to delete the row, it states "The search key not found in record."

In the past, I have been able to get all users to exit the database and then
go back in and everything is fine. This time, it did not work.

Any suggestions? I don't know what the users do before this error occurs to
figure out why it is happening. Thanks
 
That seems to be something of an all-purpose error message. It could be
something like a user entering text into a number field, or leaving a field
blank in a situation where a null value won't work because of some code.
Without knowing more about your database's structure it is difficult to offer
an informed suggestion. I would suggest you check Google groups, with
something like this in the search box:
Access "error handling"
There should be quite a few discussions, and one will probably be close to
your situation. If you can identify the error you will have a much better
chance of figuring out how to prevent it.
 
Back
Top