Form Wizard not showing Select Query Fields to attach to form.

[Phred]

Access 2007 and SQL Server 2008 R2 Back End, in development.

I have created two select queries. Both queries perform correctly and call up the correct data.

Query 1: QRY_AODOCSUM

SELECT dbo_PropertyYearDetail.PropertyID, dbo_PropertyYearDetail.PropYearDetID, Left([taxyear],4) AS TaxYear, dbo_PropertyYearDetail.AOfileDT, dbo_PropertyYearDetail.AOComplaintNO, dbo_PropertyYearDetail.AOcertifiedAV, dbo_PropertyYearDetail.AOProposedAV
FROM dbo_PropertyYearDetail INNER JOIN dbo_Property ON dbo_PropertyYearDetail.PropertyID=dbo_Property.PropertyID
WHERE (((dbo_PropertyYearDetail.PropertyID)=[Forms]![property]![PropertyID]))
ORDER BY Left([taxyear],4);

Query 2: QRY_BORDOCSUM

SELECT dbo_Property.PropertyID, dbo_PropertyYearDetail.PropertyID, dbo_PropertyYearDetail.PropYearDetID, Left([TaxYear],4) AS TaxYear, dbo_PropertyYearDetail.BORfinalAV
FROM dbo_PropertyYearDetail INNER JOIN dbo_Property ON dbo_PropertyYearDetail.PropertyID = dbo_Property.PropertyID
WHERE (((dbo_Property.PropertyID)=[Forms]![Property]![PropertyID]))
ORDER BY Left([TaxYear],4);

Query functions and pulls up the proper data. QRY_AODOCSUM:



Query functions and pulls up the proper data. QRY_BORDOCSUM:




These two queries will display on the Main Property Form as sub_Forms. Both queries pick up the PropertyID from the Property Form and pull up the data in the query. The sub forms display their data only by query. There is no direct connection between forms such as Property Parent Form ID to Property Sub Form AODocSum sub form Property ID. (Perhaps I need one??)



Here is the problem. When I go to the Form Wizard to create the form and select the Query to attach to the form, no fields show:

Form wizard to build on QRY_AODOCSUM



Form wizard to build on QRY_BORDOCSUM



I have not encountered this before. Does anyone have any ideas?

Thanks Phred

[Phred]

I've tried to attach the queries a bunch of different ways and they don't work. I think there is something fundamentally wrong with my queries.

[Phred]

I found I had a circular reference in a field in the query. The formula in the query was Left([TaxYear],4) to return the year portion of the Date. At the same time I was trying to Sort Descending by this field.