Form pop up at open of a form . . .?

G

Gabriella777_2

I would like to set a form to open up with a pop that asks if they would like
to go to a new entry screen or not. If they click yes, it does so. If they
click no, it opens as if they never had to deal with the pop up question.
Is there a way to do that in Access 2000?
 
C

Chegu Tom

in the code for the button you use to open the form use a messagebox

If MsgBox("Do you want to open the New Entry Screen", vbYesNo) = vbYes Then
DoCmd.OpenForm Formname_for_new_entry
Else
DoCmd.OpenForm Formname_for_other_entry
End If
 
G

Gabriella777_2

I have this with a couple minor changes but when I run the debugger it keeps
flagging the actual message say it expects GoTo or Then or that it is an
outside procedure. What's missing? I also kept getting message that a
separator was need.(?)
Here is what I have . . .

If Me!MsgBox "Do you wish to Enter New Reports?", ([vbYesNo] = vbYes) Then
DoCmd.OpenForm [Form_Log Entry Form]
DoCmd.GoToRecord , , acNewRec
Else
DoCmd.OpenForm [Form_Log Entry Form]
End If
--
Thanks and God bless you and yours,
Gabriella777_2



Chegu Tom said:
in the code for the button you use to open the form use a messagebox

If MsgBox("Do you want to open the New Entry Screen", vbYesNo) = vbYes Then
DoCmd.OpenForm Formname_for_new_entry
Else
DoCmd.OpenForm Formname_for_other_entry
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top