Only one record shown in sub form

[paulcraigdainty]

I have a form with a sub form. The parent form has a field called 'ReportedBy'. The user enters their name in this field. I want the subform to display all records that have been created by the name in ReportedBy. I have based the subform source object on the following sql query:

SELECT *
FROM tblFault
WHERE tblfault.reportedby=[forms]![frmfault]![reportedby];

The sub form only shows one record even though there are more records in the table????

 

[Newman]

In the properties of the subform, set «DefaultView» to «Continuous».

 

[paulcraigdainty]

Hi i cant seem to find the default view option within properties

 

[Newman]

I am talking about the properties of the form "subForm".
Not about the properties of the object subform on the main form.
I hope that it is clear. I can't find the words to make it easier to understand.

 

[paulcraigdainty]

that worked fine, thanks