could someone help me with this

[helloworld]

Hi there,

I have got a form where I have three foreign keys in them. when I try to save a record, it gives me this error message.

"The Microsoft Jet Database Engine cannot find a record in the table [name of table where the foreign key is being linked from] with key matching field(s) [name of foreign key]"

Now I have a Message box in my code that pops up when the field is not filled in. How do I get rid of this error? Any help would be great!

 

[helloworld]

Hi Pat,

Thanks for your reply. However, I am still getting that stupid message. Any further thoughts?

 

[helloworld]

Yeah...I am pretty sure they are. However, what type of link should I be using(1, 2 or 3)?

 

[helloworld]

Yes it does. I dont know why this it is doing this. the message only comes up when I click the close button or to go to design view however. It does not show up when I click the save button.

 

[helloworld]

I will check that out! Thanks for the tip!