It should be open, because I open it with my form and close
when I close my form. Also the grid is populated which
should show an open query. The records disappear
(sometimes) when I press Insert button.

Riho-Rene Ellermaa
Ellermaa Tarkvaratöökoda
http://www.ellermaasoft.ee

> Hi!
>
> I think you should check if your query is open while (or

just before)

> inserting records.
>
> I had a problem recently that might have a similar cause:

I was using Commit

> which normally closes your query. What I didn't know is

that you can post

> records to queries that are not open ...
>
> Cheers,
> Tobias
>