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!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Form based on a query not working
- Thread starter robert693
- Start date
Similar threads
- Locked
- Question
