edit button in subform

[rg2005]

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 button is

SELECT DISTINCT [BookID], [Genre],[Title],[Author],[Available_in_library] from qrySearch WHERE 1=1

and i was wondering how to put the button in the sub form

 

[gromit]

Hi - You need to switch the subform to form view (looks like datasheet view from your image).

- g