MajP
You've got your good things, and you've got mine.
- Local time
- Today, 02:08
- Joined
- May 21, 2018
- Messages
- 8,463
You call the function in the current event of the subform, and to make it work you pass a sessionDayID. However when you go to a new record it is null.
2 ways to fix
1. NZ
2. If then
Let me see if I can decipher the other questions.
2 ways to fix
1. NZ
Code:
Me.sbfrmSessionDay.Form!txtStudents = ConcatRelated("Student", "qryStudentSessionTimeConcat", "fldSessionDayID = " & Nz(Me!sbfrmSessionDay.Form!fldSessionDayID, 0))
Code:
IF not isnull(Me!sbfrmSessionDay.Form!fldSessionDayID) then
Me.sbfrmSessionDay.Form!txtStudents = ConcatRelated("Student", "qryStudentSessionTimeConcat", "fldSessionDayID = " & Me!sbfrmSessionDay.Form!fldSessionDayID
end if