Hi,

I am using Access 2003.

I am trying to add an Event Procedure in the AfterUpdate Property on my main
Form

Basically, I have a field called "Complete" and it is a Yes/No check box on
my main form.

Then, I have a field called "FundsIn" and it is a Yes/No check box on my
SubForm.

I have both check boxes because my team works on Transfering accounts from
Fund Companies to us and we may be transferring an account from CIG and from
AIC but they may or may not be transferred at the same time. Therefore, I
want our processors to have the option to say either AIC funds are in,
FundsIn = True but CIG funds are not in, FundsIn = False OR both funds are in
- Complete = True

Hence, I am trying to do something like this...

  Private Sub IsSelected_AfterUpdate()
      If Me.Complete = True Then
          Me.FundsIn = True
      Else
          Me.FundsIn = Null
      End If
  End Sub

However, I am getting an error message "Compile Error: Method or Data Not
Found" And I believe that I am getting this error because the Complete
Indicator is on my main form and my FundsIn Indicator is on my SubForm. Both
Forms have their own Query to eliminate the "Criteria" questions from
repeating themselves.

Is there any way that I can get around this compile error to complete this
Event Procedure?

Thank you so much in advance ;)

Mellissa