Solved How to close query in accde and go back to form (1 Viewer)

[Tea]

Hi,

so I have this form, where I can choose from the option buttons and input date in textfields after that I click on the button "Show data" and it opens a query based on the filter I made on my form. Except after I get the data I can't go back to the previous form in the accde version without closing the whole database. In accdb I can just close the query by clicking the x.

Is there a way to close the query in the accde file without closing the whole database?

Thank you.

 

[Mike Krailo]

I would try building a form and open that using SQL string as record source.

 

[bob fitz]

Perhaps you could use a form, with the query as its' Record Source, to present the data to the user

 

[Tea]

Perhaps you could use a form, with the query as its' Record Source, to present the data to the user

I've thought about it, but I forgot to mention, that I would like to manipulate with the data later on, e.g. copy the data to a file or filter it however i want later on in the query. I've created a button in my form with that I can export the data in excel file, but I would like to know if there was some other options...

 

[bob fitz]

I've thought about it....

But have you actually tried it

 

[gemma-the-husky]

if you have a form when you choose you may be doing this sequentially

if openquery then
   showquery
else
  openform
end if
'WAIT HERE
..
...

if you do this, your program will only do either the query or form, but won't do both.

if you have an option group and a button, then on the button click you can do this

select case grpOpen
case 1:   showquery
case 2:  openform
end if
'WAIT HERE
....
...

Now the code will still run in the background, so it might be that when you open either the query or the form, you need to stop your calling form from doing anything else until you close the query or the form. One way to do this is to open the query and form in dialog mode. The dialog setting effectively adds a 'WAIT HERE where I have indicated.

 

[arnelgp]

If you have the "source" db, it would easy to create a subform out of the query and put it on the Main form.