Main Form = Frm_Engineer_Search
Sub Form = Frm_Engineers
Frm_Engineers populated by Tbl_Engineers
I've been trying to link together a textbox with a subform so when a surname is entered into TxtSearch and CmdSearch is click it will run a query/refresh the subform displaying the correct record which correspond to the entered surname. Is this possible? I've tried entering into Qry_Engineer_Search in the Surname attribute criteria [Forms!][Frm_Engineer_Search!][TxtSearch] and add me.refresh to CmdSearch Click event but it just refreshes the whole form.
Any pointers? Thanks in advance