continous form data

[ashraf_al_ani via AccessMonster.com]

Dear All
I have a continous form that have 25 records in its detail section

is there a way to deal with one record among these 25 records


and I mean by that for example

if the record 3 has a value "100" a specific messsage box appears
the record 7 has a value "200" a specific messsage box appears


any ideas???
best regards

 

[BruceM via AccessMonster.com]

A field, not a record, will have a value. Under what circumstances would you
have the message box appear? How would you identify record 3? What exactly
distinguishes it as record 3? Does it have the value 3 in a specific field?

You could have code in the form's Current event to generate a message box
when you select a record:

If Me.RecordID = 3 Then
If Me.SomeField = 100 Then
MsgBox "Your message"
End If
End If

 

[ashraf_al_ani via AccessMonster.com]

thanks for help
but i mean the value for a record in that continous form if the value is 100
then ive got the message

but i want that happen when i open the form directly and not searcching for
the record
is there a way to handle my problem??

best wishes

 

[ashraf_al_ani via AccessMonster.com]

thanks for help
but i mean the value for a record in that continous form if the value is 100
then ive got the message

but i want that happen when i open the form directly and not searcching for
the record
is there a way to handle my problem??

best wishes

Dear All
I have a continous form that have 25 records in its detail section

[quoted text clipped - 8 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

 

[BruceM via AccessMonster.com]

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.

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]so please isnt there a way to apply a condition to a specific record in the
continous data ??

please any ideas ???

best regards