combo after update affects all records? I need it to just affect current record...

[misscrf]

I have a form for candidate entry. Then I have a subform for their application. Then I have a subform in that for the activities that pertain to that application.

Here is a screenshot of what I am trying to debug:

http://www.geocities.com/misscrf/images/continouscomboissue.jpg

When I select an activity type, for the first record, I chose interview scheduled. This makes the interview date field show. Then in the next record, I choose materials forwarded. This brings up the office combo for what office the materials were forwarded to.

The problem, as you can see in the jpg, is that when I choose the materials forwarded in the second record, it changed the previous record, making the interiew date hide. It should only show and hide at the record level. does this make sense? This is the code for the after update of the activity combo, which hides and shows conditionally needed fields....

Private Sub cmbActivityType_AfterUpdate()
On Error GoTo Err_cmbActivityType_AfterUpdate

If Me.cmbActivityType = 4 Then
Me.txtInterviewDate.Visible = True
Me.cmbMatSentOffice.Visible = False
Me.cmbOfferResult.Visible = False
Me.txtStartDate.Visible = False
ElseIf Me.cmbActivityType = 5 Then
Me.cmbOfferResult.Visible = True
Me.txtInterviewDate.Visible = False
Me.cmbMatSentOffice.Visible = False
ElseIf Me.cmbActivityType = 3 Then
Me.cmbMatSentOffice.Visible = True
Me.txtInterviewDate.Visible = False
Me.cmbOfferResult.Visible = False
Me.txtStartDate.Visible = False
Else: Me.txtInterviewDate.Visible = False
Me.cmbMatSentOffice.Visible = False
Me.cmbOfferResult.Visible = False
Me.txtStartDate.Visible = False
End If
Exit_cmbActivityType_AfterUpdate:
Exit Sub

Err_cmbActivityType_AfterUpdate:
MsgBox Err.Description
Resume Exit_cmbActivityType_AfterUpdate
End Sub


Can anyone help?
If you need more info please let me know.
misscrf

 

[misscrf]

Well, I have look around everywhere and it seems that there is no fix. There is no way around this. I am going to have to make the forms single, and then use navigation buttons. From there, I will just have to make an add record button, and I do plan to have a quick report for this candidate button on the main form.