Gasman
Enthusiastic Amateur
- Local time
- Today, 21:42
- Joined
- Sep 21, 2011
- Messages
- 14,047
Hi all,
Having a mental block here.:banghead:
I have form A which has a button to open form B with
and in the form B load event I have
Form B is merely to link a Submitter to an Introducer.
The table Form B is based on is tblSubmitter as shown in the rlationship diagram
The strange thing is the form for tblSubmitterClient is the same structure and that works fine?
I now I am doing something stupid here, but for the life of me cannot spot it.:banghead:
Could someone please point me to my error.?
TIA
Having a mental block here.:banghead:
I have form A which has a button to open form B with
Code:
Private Sub cmdAddSubmitter_Click()
DoCmd.OpenForm "frmSubmitter", , , , acFormAdd, acDialog, Me.IntroducerID
End Sub
Code:
Private Sub Form_Load()
If Len(Me.OpenArgs) > 0 Then
Me.IntroducerID = Me.OpenArgs
End If
End Sub
The table Form B is based on is tblSubmitter as shown in the rlationship diagram
The strange thing is the form for tblSubmitterClient is the same structure and that works fine?
Code:
Private Sub cmdAddSubmitter_Click()
DoCmd.OpenForm "frmSubmitterClient", , , , acFormAdd, acDialog, Me.ClientID
End Sub
Private Sub Form_Load()
If Len(Me.OpenArgs) > 0 Then
Me.ClientID = Me.OpenArgs
End If
End Sub
Could someone please point me to my error.?
TIA