Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Open 2nd Pop Up Form After Main Pop Up Form 1

Status
Not open for further replies.

pjd218

Technical User
Apr 14, 2008
40
US
I have a form (PROJECT_FRM)that is a popup called from a command button from the switchboard and is bound to a table for data entry.

What I would like to accomplish is to have a 2nd popup form PROJECTHELP_FRM (which is an unbound form) open after the PROJECT_FRM opens.

PROJECTHELP_FRM has a command button that allows the user to close the form. The main purpose of the 2nd popup is to have the form data entry instructions displayed to the user.

Ultimately, the PROJECTHLP_FRM would have checkbox that the user could select to disable the form from opening once they are comfortable with the data entry process on the form. I have a command button on the form PROJECT_FRM to open the PROJECTHELP_FRM as well and this works fine (2nd form on top of the main form).

I have seen a couple of posts stating you cannot open 2 popups at basically the same time.

Tried a couple of ideas (OnOpen, OnLoad and the 2nd form loads behind the first). No way to resize the 1st form.

Ideas?
 
How are ya pjd218 . . .

PROJECT_FRM needs more time to reach a certain state before PROJECTHELP_FRM can be opened. This can be accomplished by using PROJECT_FRM's timer as follows:
[ol][li]In the [blue]On Load[/blue] event of PROJECT_FRM, copy/paste the following:
Code:
[blue]   Me.TimerInterval = 500[/blue]
[/li]
[li]In the [blue]On Timer[/blue] event, copy/paste the following:
Code:
[blue]   DoCmd.OpenForm "PROJECTHELP_FRM"
   Me.TimerInterval = 0[/blue]
[/li][/ol]
Thats it ... perform your testing!

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue] [thumbsup2]
Also faq181-2886 [blue]Worthy Reading![/blue] [thumbsup2]
 
Ace,

You are tha Man!

I knew it was an easy fix but I am a self taught programmer, though not a very good student!

Another one for ya!

I need the user to be able to click a check box on the unbound 2nd form that will prevent it from opening again.

Kind of like the info screen when you first install a software program (Start Up Tips).



 
pjd218 . . .

This would be a good time to start another thread. I'm sure alot of members who need the same secnario will be watching. I'll be sure to pick it up . . .

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue] [thumbsup2]
Also faq181-2886 [blue]Worthy Reading![/blue] [thumbsup2]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top