After much searching and combing through possible threads I have finally resigned myself to asking for help.
I have used the Switchboard Manager (yes learning this wasn't such a good idea).
Req: When a user selects the 1st command button (Projects) on the default switchboard (main)
1. a reminder message pops up, they select ok ( then either manually exit the dbase or continue
2. the designated form opens ready for viewing / entry etc.
I have gone through many iterations but the last code is as follows:
Private Sub Option1_Click()
On Error GoTo Option1_Click_Err
If [SwitchboardID] = 1 And [ItemNumber] = 1 Then
MsgBox "Tier 3 Projects are NOT to be recorded in this system.", vbOKOnly, ""
DoCmd.OpenForm "FrmProjectData", acNormal, "", "", , acNormal
If Not [SwitchboardID] = 1 And [ItemNumber] = 1 Then Resume