Query Crashes Program

  • Thread starter Thread starter AlmanME
  • Start date Start date
A

AlmanME

Guest
I have a main mailing list table with three related tables. One holds the town/state/zip info in a many to one. Another holds a membership Code in a many to one. The third is a one to one table that contains person specific registration information.
I built a query that draws from the main form and the registration information and a form to use in data entry/editing. Works great until I added the third table into the query to filter only one membership code. Now, if I try to add registration info into the query or form, Access crashes. Removed the criteria from the query, but problem persisted.
Why? Suggestions?
 
Could you post the SQL for the query here so that we can see it.
 

Users who are viewing this thread

Back
Top Bottom