I have a command button that executes a series of SQL based queries. It appears as though everything is working fine, b/c no error pops up, it just freezes at the end, leaving me no option but to close the db entirely. I am trying to open a query as the end result of clicking the button by using DoCmd.OpenQuery. But the query never appears. I even tried putting in message boxes before and after the open query line and even before the query code. All the message boxes pop up, but the query still doesn't.
If you need to see the code, let me know.