Access Db Issue - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Access Db Issue

Ken Dianovich

2 days ago

I am getting the following error in my Access Database when I am in a Form and go to close it

"The Microsoft Access database engine cannot find a record in the table 'HospitalContactT' with key matching field(s) 'HospitalContactID'"

Any suggestions would be greatly appreciated.?

	Raymond Spornhauer @Reply 2 days ago
Is this only happening on New Records? If you have code running on the Form Close or Form Unload referring to a record that doesn't exist (because it's new and not saved to the table) you will get this error. -Raymond

	Juan Rivera @Reply 2 days ago
I think check to see if recorord is dirty and perform an undo. you may be trying to close a form before its saved. Undo Dirty

	Donald Blackwell @Reply 2 days ago
To piggyback on Juan, or perhaps there may be some code looking for the ID of a deleted record, if you allow deletes.

	Ken Dianovich OP @Reply 15 hours ago
I believe my Issue is when I am using Different Tables within the Form, just need to figure out how to do that without the error.

	Juan Rivera @Reply 9 hours ago
It sounds to me like you may need to use recordset.

Next Unseen

New Feature: Comment Live View