I'm not familiar with the syntax for the Expression Builder for a control's Source ( other than very basic). I want an output, based on another field's value on teh same subform ( Like a SELECT .. WHERE Clause in SQL. In fact, here's the equivalent SQL
Any suggestions gratefully received.
Code:
"SELECT tblStaff.CalcStaff_Name FROM tblStaff WHERE tblStaff_ID=" & Me.Recordset!Staff_ID & ";"
Any suggestions gratefully received.
