Form based on query not working. (1 Viewer)

[robert693]

I have a form based on a query. The query is based on three tables. One table is called Institution, it holds information about universities, hospitals and other institutions. Another is called Contact, which holds information about contacts from the institutions. A third table joins the two and hols information from surveys the institution sends us. The form we use to enter this infomation allows us to enter information about the contact and the survey. Entering info about the contact is fine but when a person enters info about the survey a error message appears that says "join key of Survey not found in recordset". I am able to click out of the form and come back in to the sme record and then the message does not appear. Can anyone help with this? I would greatly appreciate it!

 

[David R]

Please don't post the same thing in multiple forums

Several people have already posted possible solutions to your identical post in another forum. Duplicated posts leads to duplicated effort.

Post back there if you have further trouble with this.