i want to create an edit button as seen in the picture below in my subform, the record source for the form in the picture is,
SELECT tblLoans.*, IIf([Status]<>"Closed","Edit","") AS Edit, * FROM tblLoans ORDER BY tblLoans.Title;
and the record source in the sub form where i want the edit...