Galphanore
Registered User.
- Local time
- Today, 04:08
- Joined
- Apr 5, 2006
- Messages
- 23
I have a text box on my main form with this equation :
=IIf(Child123.Form!Combo27="2","Active"," ")
It is supposed to show the word "Active" if the combo box in my subform has the second option selected, the options of the box are "Pending" "Active" and "Complete". It works great as is, as long as the active record in the subform is showing. Is there any way to make it search through the subrecords for all the values for Combo27 (Which is stored in a table under the value "Status")?
It would even work fine if I could just make it so the most recently added subrecord would be the first one displayed, because there cannot be more then one active at a time.
=IIf(Child123.Form!Combo27="2","Active"," ")
It is supposed to show the word "Active" if the combo box in my subform has the second option selected, the options of the box are "Pending" "Active" and "Complete". It works great as is, as long as the active record in the subform is showing. Is there any way to make it search through the subrecords for all the values for Combo27 (Which is stored in a table under the value "Status")?
It would even work fine if I could just make it so the most recently added subrecord would be the first one displayed, because there cannot be more then one active at a time.
