If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#Name? - Change when appears
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? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200710/1 |
#2
|
|||
|
|||
#Name? - Change when appears
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 "Alaska via AccessMonster.com" u36428@uwe wrote in message news:79700b9287257@uwe... 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? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200710/1 |
#3
|
|||
|
|||
#Name? - Change when appears
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 Boyce wrote: 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 [quoted text clipped - 4 lines] of 0 or have an alternate message appear other than #Name? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200710/1 |
Thread Tools | |
Display Modes | |
|
|