L
Lori S.
I have created a form that I use just to look up
information that is in many tables, so I don't have to
open each table individual to look up information. There
are multiple links to my tables and it has been a tedious
task to look up information in all the tables concerning a
particular id (all tables except one have a one to one
relationship with an id number; the other table has a one
to many relationship). I don't use this form for data
entry or update or delete. Not every table has
information on the id number I enter but that is to be
expected. When I exit the form I get the following error
messages:
1. "The Microsoft Jet database engine cannot find a
record in the table 'Workstation' with key matching field
(s) 'ID_tags_id_tag'.
2. "You can't save this record at this time. Microsoft
Access may have encountered an error while trying to save
a record. If you close this object now, the data changes
you made will be lost. Do you want to close the database
object anyway?"
Both errors are to be expected, but I want to know if
there is any error capturing code I can drop into my form
that will eliminate the viewing of these messages.
information that is in many tables, so I don't have to
open each table individual to look up information. There
are multiple links to my tables and it has been a tedious
task to look up information in all the tables concerning a
particular id (all tables except one have a one to one
relationship with an id number; the other table has a one
to many relationship). I don't use this form for data
entry or update or delete. Not every table has
information on the id number I enter but that is to be
expected. When I exit the form I get the following error
messages:
1. "The Microsoft Jet database engine cannot find a
record in the table 'Workstation' with key matching field
(s) 'ID_tags_id_tag'.
2. "You can't save this record at this time. Microsoft
Access may have encountered an error while trying to save
a record. If you close this object now, the data changes
you made will be lost. Do you want to close the database
object anyway?"
Both errors are to be expected, but I want to know if
there is any error capturing code I can drop into my form
that will eliminate the viewing of these messages.