Close Query

[char_li]

Hello.

I am presenting data through straight queries. But if the query is open when I click the button, the query doesn't update.

I tried several things.

DoCmd.Close(acQuery, stQueryName, acSaveNo)
But errors said it needed an =, so I did
x = DoCmd.Close(acQuery, stQueryName, acSaveNo)

[Tonker]

Sorry, not too familiar with that.

Is it VB you're using?

[char_li]

Just Access 2000. I believe it uses VB. Making it requery would work too, but I keep getting errors when I try that. I hate it when something simple takes me 2 days to figure out. Usually, it is something stupid I am missing.

Thanks for the quick reply. I will click, well, I was going to say I would click a few banners for you, but you don't have any. I have found a home. :)

[Tonker]

I'm afraid my knowlwedge of access is pretty limited. I haven't used it in a few years and even then I had very little exposure to it. Have you tried looking at the MSDN site. They have some tutorials and FAQs there that might help.

Sorry I can't be of more help in this.