How do I add to the end of my code to goto a new form? The form name is Attendance
Private Sub Command36_Click()
If IsNull(Me.Combo63.Value) Then
MsgBox "Input By?", vbCritical, "Input Error"
Me.Combo61.SetFocus
Me.Combo63.SetFocus
End If
End Sub
How do I add to the end of my code to goto a new form? The form name is Attendance
Private Sub Command36_Click()
If IsNull(Me.Combo63.Value) Then
MsgBox "Input By?", vbCritical, "Input Error"
Me.Combo61.SetFocus
Me.Combo63.SetFocus
End If
End Sub
dosent work Compile Error
I also tried this and no go!
Private Sub Command36_Click()
If IsNull(Me.Combo63.Value) Then
MsgBox "Input By?", vbCritical, "Input Error"
Me.Combo61.SetFocus
Me.Combo63.SetFocus
DoCmd.GoToRecord , , acNewRec.
End If
End Sub
Did you add the required arguments to the OpenForm? Is that period actually in the code?
First you talk about going to a a 'new Form,' then you use code to go to a New Record, and you also set Focus on two different Controls consecutively, which makes no sense at all!
I think, perhaps, you need to simply explain, in plain language, what your scenario is and what you're trying to accomplish, if we're to help you.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007