2nd Datasheet is hidden behind 2

[cimoli]

I used the wizard to make a button on a form that i show in datasheet view.
The view comes up nicely as usual. I hit the new button to see a different datasheet.

Nothing seems to happen. I exit the initial datasheet screen.
Lo and behold, the 2nd datasheet was hidden behind.

How can i make the 2nd datasheet (based on a qry) show until i click out,
and return me to the 1st datasheet (based on form) ?

 

[PHV]

What is the code behind the new button?

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

 

[cimoli]

I don't know. The On Click just says [Embedded Macro] whereas my old programming method would have said
"event procedure". I think that i am suppose to graduate up to the newer embedded macro method for some reason.
so i tried it for the 1st time. Shall i go back to "event procedure" method ??

 

[cimoli]

I redid my button On Click to be "event procedure". I put in this code.

Private Sub cmdCalCreator_Click()
DoCmd.OpenQuery "Qry3995CalendarCreator"
DoCmd.Maximize
End Sub

I get the same problem. I am on my Form that is shown in datasheet view.
I hit the button, trying to have a simple query show.
Instead, nothing seems to happen.

But when i close the Form, i can see that the qry had run. it was in the background, hidden.

how can i make the qry only show. and when i "x" out of the qry,
i would go back to the form?

 

[dhookom]

Was the form with the code opened as dialog?

Have considered not opening a query and instead opening a form based on a query?

Duane
Hook'D on Access
MS Access MVP

 

[cimoli]

Hi Duane. I thought of it and I guess that is my only choice. it work for me. I probably can copy paste a field that is inside the form. I will try it now.

 

[cimoli]

Duane - yes, I opted for a new form using the qry. used continuous form and made a separate button. So all is good. Thanks for pushing me into that direction.