Trying to Create a pop-up form

[tbmarlie]

Due to size limitations on my main form, I am trying to create a form
that, when I select a button, it pops up like a dialog box with the
main form, Frm_Escheat, in the background

I've created a qry which is the record source on my pop-up form. In
the criteria of the query is:

[Forms]![Frm_Escheat]![statecode] where [statecode] is the
field from the Master Form.

So, my "pop-up" form is activated when I select the button, but my
problem is that it just goes to the pop-up form without the main form
showing in the background.

Thanks for your help.

 

[Linq Adams via AccessMonster.com]

It would probably help if you showed us the code you use to open your popup
form as well as any code you have in the popup form's OnLoad event.

 

[tbmarlie]

It would probably help if you showed us the code you use to open your popup
form as well as any code you have in the popup form's OnLoad event.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted viahttp://www.accessmonster.com

The code to open is:

Private Sub DormancyInfo_Click()
On Error GoTo Err_DormancyInfo_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Frm_Dormancy_Info"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.MoveSize 1440, 2400, 2000, 2000

Exit_DormancyInfo_Click:
Exit Sub

Err_DormancyInfo_Click:
MsgBox Err.Description
Resume Exit_DormancyInfo_Click

End Sub

I don't have anything in the OnLoad or OnOpen events.

 

[Linq Adams via AccessMonster.com]

Which form do you think this line of code is being applied to?

DoCmd.MoveSize 1440, 2400, 2000, 2000

If you intended it to apply to the popup form, that may be your problem. It's
actually being applied to the your original form, and making it very small,
less than 1.5" x 1.5" I suspect it's hiding behind the popup.

 

[tbmarlie]

Which form do you think this line of code is being applied to?

DoCmd.MoveSize 1440, 2400, 2000, 2000

If you intended it to apply to the popup form, that may be your problem. It's
actually being applied to the your original form, and making it very small,
less than 1.5" x 1.5" I suspect it's hiding behind the popup.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted viahttp://www.accessmonster.com

The MoveSize code s/b getting applied to the pop up form. I was just
putting in some numbers to test it to hopefully see where it would
visually line up in the Main Form (and then I would adjust the numbers
more accurately), but they didn't seem to take hold. I ran without
this line and got the same thing - the entire screen would contain the
pop up form and then the only way to see my Main form would be to
close the pop up form entirely which defeats my intended purpose of
trying to see the pop information with the main form in the
background.

 

[Douglas J. Steele]

Try

DoCmd.OpenForm stDocName, WindowMode:= acDialog

(Since you're not setting any criteria, there's no need to include
stLinkCriteria in the OpenForm call)