Opening form using combo box as filter

speakers_86

Registered User.
Local time
Today, 16:10
Joined
May 17, 2007
Messages
1,919
Code:
Private Sub Go_Click()
If IsNull(Me.Combo0) Then
Else
DoCmd.OpenForm "frmTransactions", , , "AccountID=" & Me.Combo0.Column(0)
End If
Me.Visible = False
End Sub

This works fine, but if there are no transactions with the selected accountid, then the form opens blank. All I get is a white screen. How can I get the form to open and show the controls so the user can input info?
 
Speakers,

Do you have the AllowAdditions property of the frmTransactions form set to Yes?
 

Users who are viewing this thread

Back
Top Bottom