[RESOLVED] Access 2003 - Binding A TextBox To Fields In A Query

[Hack]

I have three queries stored in an Access Database.

Each query is completey identical with respect to the SELECT clause. It is selecting all fields in a table, which I list out individually. The only difference in the three queries is the WHERE clause. There are three records in the table on which these queries are based. Each record has 24 entries. The first entry indicates the record type (in this case, type equals either "Family" "Peds" or "Adult")

On a form I have three sets of 23 textboxes, for a total of 69. Each set of 23 textboxes should display the values in the fields resulting from the field in the query to which the textbox is bound. For example the 23 textboxes bound to the "Family" query will display the values for each field in the record where type = 'Family'; the 23 textboxes bound to the "Peds" query will display the values for each field in the record where type = 'Peds'; the 23 textboxes bound to the "Adult" query will display the values for each field in the record where type = 'Adult';

The fields in the three separate queries are identical.

In the control source for the 23 textboxes on the Family group I have =[gryFamily!FieldName]
In the control source for the 23 textboxes on the Peds group I have =[gryPeds!FieldName]
In the control source for the 23 textboxes on the Adult group I have =[gryAdult!FieldName]

Everything keeps coming up with #Name?

Incidentially, in this scenerio "Group" means nothing more than a set of textboxes all lined up together. They are not programmatically related in any way other than being bound to the same query, but different field in that query.

I'm redoing an existing form. On the existing form there is a data control which moves between the three records and flawlessly display the proper values. Management does not want to have to do this. They want the values for all three "types" displayed at the same time when the form opens. Thats what I'm trying to do. I've never done anything like this with Access before, so I don't know why I'm getting the #Name? thing for two of my sets of textboxes. I done a fair amount of Googling and have found things mentining the #Name thing, but I'm still not sure what I'm doing wrong here. From what I've read I am, theoretically anyway, doing what I'm supposed to be doing.

Screen shots representing one field in each of the three queries.