close an open form

[Junkie88]

i have a form based on a query. when i have finished going through the recordset, i want to open the form with a different record set.

because i am using some of the variables on the first instance of the form to create the second instance, i need to keep the form opened. once i am done with the calculations, i want to close the form and then reopen it.

how do i check whether the form is open or not?

i want to see that if the form is open, if it is then i close it.

 

[TheAceMan1]

Junkie88 . . .

A little more detail would help on what your doing with the recordset, but have you tried a requery?

[blue]   Me.Requery[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[Junkie88]

i was thinking about what requery means? is it going to change the record set on which my form is based?

the query returns a record set consisting of questions that can be answered in one way, i.e. as yes or no. The second time, i want to get those questions that are answered as either hard or easy. so the query is basically extracting certain kind of questions from the table and showing them on the form.

 

[PHV]

how do i check whether the form is open or not?
A starting point:
If Application.CurrentProject.AllForms("yourForm").IsLoaded Then

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

Junkie88 . . .

Well . . . are you adding criteria to the query, filtering or what?

Post the code your doing this with!

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886