Form and Subform

[Syla]

My form shows employee details by their surname. So when you open this form you get asked for a parameter value (surname). I want my subform to show all employees with that surname and when I update it in the form i want the change to show in subform.

[davegri]

Do you have two tables? Generally a form/subform arrangement is for two tables with a One-to-Many relationship. The main form shows the ONE table while the subform shows the MANY table.

[ranman256]

you dont need a subform.
in a continuous form that shows all employees, enter the name in an unbound text box, then filter the list:

sub txtBox_afterupdate()
if isNull(txtBox) then
   me.filterOn = false
else
   me.filter = "[surname]='" & txtBox & "'"
   me.filterOn = true
endif
end sub

[Syla]

I have a form that only shows one employee then i press the next button it shows a different employee - so the form only shows 1 employee each time whereas I want the subform to show all the employees that have the surname 'smith'

[Syla]

The form is created using a query which is made using many tables

[davegri]

Syla, in reply to your last two posts, #4 and 5, Ranman's advice is appropriate. However, a form based on such a query may not be able to update records.