form tied to union query

I have a form that pulls data from a union query. It also gets data from a few more queries, all with different criteria. Initially, i made the union query with the statement 'UNION SELECT', but one machine in our group kept getting the error message 'can't use a memo field with the SELECT statement of a union query'. I found the fix to that to be changing my query statement to 'UNION ALL SELECT'. I ran the query and there it was - everything is fine on all machines. The problem now is the form that uses this data won't open. When I start it, the hour glass comes up for a minute and then just goes away. I can open it in design view but I get a new error message and then have to use Task Manager to shut down Access. Seen this one before? If I answer yes the error message just comes back up. No jjust puts me back in desin view. Any ideas where this thing is hung in the code?