Can't save record. The Microsoft Jet database engine cannot find a

J

James1954

I have an autolook up query that automatically fills data in on a form. The
primary key is the phone number. It works fine when I it finds a matching
key. If it doesn't find a matching key and I try to save the record I get the
following message. The Microsoft Jet database engine cannot find a record in
the table <name> with key matching field(s) <name>. (Error 3101). I
understand what this is telling me, but is there a way to save a record when
the fields do not match. Is there a way of bypassing this.

Thanks
James1954
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top