Martyh
Registered User.
- Local time
- Today, 11:24
- Joined
- May 2, 2000
- Messages
- 196
Hi!
How can you tell (programmatically) if there is value in a Child ?
eg Me!sfrmAttachmentDetails.Form!ParticipantID
I currently have a form and a sub form in a typical 1 to many relationship.
I would like to know how I could determine if there is data entered into the many side of the relationship.
This is for a deletion control on the main form:
1) On delete of the many, if there is none, do nothing.
2) If there is, then delete.
I have no. 2 figured out but I just can't get my head around No. 1
Please HELP!!
Have already tried:
isNull(Me!sfrmAttachmentDetails.Form!ParticipantID)
isEmpty(Me!sfrmAttachmentDetails.Form!ParticipantID) &
isError(Me!sfrmAttachmentDetails.Form!ParticipantID)
None of these appear to work!
How can you tell (programmatically) if there is value in a Child ?
eg Me!sfrmAttachmentDetails.Form!ParticipantID
I currently have a form and a sub form in a typical 1 to many relationship.
I would like to know how I could determine if there is data entered into the many side of the relationship.
This is for a deletion control on the main form:
1) On delete of the many, if there is none, do nothing.
2) If there is, then delete.
I have no. 2 figured out but I just can't get my head around No. 1
Please HELP!!
Have already tried:
isNull(Me!sfrmAttachmentDetails.Form!ParticipantID)
isEmpty(Me!sfrmAttachmentDetails.Form!ParticipantID) &
isError(Me!sfrmAttachmentDetails.Form!ParticipantID)
None of these appear to work!
Last edited: