Thanks Tracy:)
>I'm glad you got it working. I would look for any dangling references or possibly the calling form has the tables already in use before this form is used? I didn't catch all of your messages in this thread so I'm not sure where the tables are opened initially or if a table is created from a view or what. By general rule, if you open a table in the form's load event, close it in the form's unload event (or that is my general rule of thumb anyway).
>
>Tracy
>
- Ravi
True greatness consists in being great in little things.
- Charles Simmons