You could use DLookup. If the continuous form is a subform, in the main
form's Current event:
If Not IsNull(DLookup("YourField]","[YourTable]", _
"[YourField] = 100 AND [ID] = " & [ID])) Then
MsgBox "Your message"
End If
[YourField] is the field that could have a value of 100. [ID] is the linking
field. Use your actual field names. Repeat the code for other values.
If the continuous form is the main form, place the code in the form's Load
event to see the message when you first use the form.
ashraf_al_ani wrote:
thanks for help
but i mean the value for a record in that continous form if the value is 100
[quoted text clipped - 11 lines]
any ideas???
best regards
so please isnt there a way to apply a condition to a specific record in the
continous data ??
please any ideas ???
best regards
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201004/1