Unanswered: Combo box and subform - please help!!!
I have a form that contains an unbound combo box and a subform. The combo box has a list of organizations and once the user selects one organization from the combo box the subform shows the records. Now the problem I am having is that if the record doesn't exist, I want to create it. So basically, if findfirst doesn't work then addnew. I got this to work but it creates 2 records in my table for some reason and I can not figure out why. Here is code for the combo box:-
Private Sub cbo_Organisation_AfterUpdate()
searchtxt = "[OrgID] = " & [cbo_Organisation]
If Me.RecordsetClone.NoMatch Then
Me.Recordset.OrgID = [cbo_Organisation]
Me.Bookmark = Me.RecordsetClone.Bookmark
Forms![Tbase].[TBase2].Visible = True
Can anyone please tell me why I keep creating 2 records?