continous form data

  • Thread starter ashraf_al_ani via AccessMonster.com
  • Start date
A

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
 
B

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
 
A

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
 
A

ashraf_al_ani via AccessMonster.com

ashraf_al_ani said:
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
 
B

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.



ashraf_al_ani said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top