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

  • Thread starter Thread starter Gabriella777_2
  • Start date Start date
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?
 
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
 
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
Click to expand...
 
Back
Top