Link one Entry to result of other Record

[Mehran52]

Hi Experts,
What I want to do I have one form thats include a lot of entry but I would
like to add one conditional link when I want to go to next record , It ask me
you didn't complete these 2 filed are you want to leave those Blank? "Yes" or
"No"

Actually if one of this two field is Filled up that's enough ,
Let me Explain again we had Three Field
1:Control Measures
2:Related Action ID Number
3:Related WBS Number
How can i add this condition to Control Measures field to have a look to 2
other cell and generate that question,

Thanks,
Mehran

 

[Douglas J. Steele]

What I typically do is create a function along the lines of:

Function GetWBSNumber()

If IsNull(Me.ControlMeasures) = False And _
IsNull(Me.RelatedActionIDNumber) = False Then

' put the code to determine the WBS Number here

Me.RelatedWBSNumber = ValueDetermined

End If

End Function

I'd then call that function in the AfterUpdate event of both the
ControlMeasures and RelatedActionIDNumber text boxes.

Note that if the WBS Number can be strictly derived from the values of the
other two fields, it should not be stored in the table: instead, it should
be added to a query as a computed field, and that computed field bound to
the text box on the form. (In other words, what I gave you above would be
completely unnecessary)