"#Name?" Error for only one cell of a record in a query? PLEASE HELP!

[Ryan Clair]

Yeah, I have a query that is populating in a subform. In the WHERE
clause I have one of the fields outside of the subfield. It shows
everything fine except the particular table's (that I'm querying) key,
which shows an "#Name?" value in it.

Also, when I design view it and then view it again, it shows it
properly. Is this a subform problem or a query problem?

Thanks in advance,

Ryan

 

[Guest]

Check to make sure that none of your form controls have the
same name as the field.

(david)