#Name? - Change when appears

  • Thread starter Alaska via AccessMonster.com
  • Start date
A

Alaska via AccessMonster.com

I have a form based on a query. The query output will change depending on
the user selection of associated data used by the query. The form fields
contains all variations. When the query does not supply the data for the
form, #Name? appears in the form field. The form is providing the output as
expected. When #Name? appears, can this be replaced with a default value of
0 or have an alternate message appear other than #Name?
 
J

Jeff Boyce

Access displays #Name when it cannot recognize the source of the control in
the form (or report).

Are you saying that you are sending DIFFERENT collections for fields to the
same form?

If so, you may have to rename those fields in your query(ies) so they all
match the fieldnames the controls expect to receive.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
A

Alaska via AccessMonster.com

Thanks for your response. The main query supplying the form is make up of
multiple queries. Each subquery is set up to display all fields, i.e., "*".
This allows me to not be specific in field selection, but the main query will
show all active fields with the field names from the subqueries. The main
query fields will change depending on operator input. This method, works in
my circumstance. I can live with the #Name? displayed in the fields of the
form, however, I wanted to see if Access would allow a default or other
comment (code?). This would be for aesthetic reasons only.

Jeff said:
Access displays #Name when it cannot recognize the source of the control in
the form (or report).

Are you saying that you are sending DIFFERENT collections for fields to the
same form?

If so, you may have to rename those fields in your query(ies) so they all
match the fieldnames the controls expect to receive.

Regards

Jeff Boyce
Microsoft Office/Access MVP
I have a form based on a query. The query output will change depending on
the user selection of associated data used by the query. The form fields
Click to expand...
[quoted text clipped - 4 lines]
of
0 or have an alternate message appear other than #Name?
Click to expand...
Click to expand...
 
Top