Also posted at: http://www.mrexcel.com/forum/editpos...43&do=editpost
Main form has a cbo box and several subforms. My cbo box returns a "0" and does not display the group # when selected if I have the following On Current Event on the main form:
Private Sub Form_Current()
cboGroup = Group_#
End Sub
I've always used this code is several database without trouble, does anyone have any idea what could be wrong. If I remove the code, the cbo displays the selection and subforms are populated correctly.
The latest issue is that the form does not open clean . . . all subforms are populated. Can you advise please?
Private Sub Form_Open(Cancel As Integer)
'DoCmd.GoToRecord acDataForm, Me.Name, acNewRec
End Sub
Many Thanks