Queries :: Multiple Results From One Entry

The below isn't the actual use but it is easier to explain like this...

I have a system set up on access and I have a front page (form) where I can enter the reference number (1141#2) of a building (YELDR for example).

This then fills in information in the other fields on the front page. For example address, number of doors and entry codes.

My problem is that this only displays one door and one entry code. I need it to display all doors and all entry codes so that I can just type in my reference number and have something that looks like the below but for all of them. It works fine at the moment but only for one of the results when there can be up to 10.

Reference No. YEDJR <---------------- I ENTER THIS

Address - high Street - London - UK <-------------- All of these fields are populated using the query

Doors - Green - front <-------------- All of these fields are populated using the query
- Red - side <-------------- All of these fields are populated using the query
- Orange - back <-------------- All of these fields are populated using the query

Codes - 10111 <-------------- All of these fields are populated using the query
- 10221 <-------------- All of these fields are populated using the query
- 10256 <-------------- All of these fields are populated using the query

I know this is probably nowhere near enough information but is this possible? I don't know SQL so i would have to use the designer.

This is the SQL which I have at the moment though (I didn't write it i just copied this from design view on the query)

Code:

SELECT [Site Info Data].[1141 #2], [Site Info Data].[1141 #2], [Site Info Data].[Site 2 Name],
[Site Info Data].freq, [Site Info Data].status, [Site Info Data].[Site 2 Owner], [Site Info Data].[NGR #2],
[Site Info Data].[Address #2], [Site Info Data].[Postcode S2], [Site Info Data].[Dish size #2],
[Site Info Data].[Dish height #2], [Site Info Data].[Dish Bearing #2], [Site Info Data].RCLO
FROM [Site Info Data]
WHERE ((([Site Info Data].[1141 #2]) Like [Forms]![Front Page]![txt1141] And ([Site Info Data].[1141 #2])
Like [Forms]![Front Page]![txt1141] And ([Site Info Data].[1141 #2]) Like [Forms]![Front Page]![txt1141]));