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
|
|||
|
|||
Showing Unbound fields in form to report.
Hi, Is there anyway to display some unbound fields in a form to report? To be more specific, this is the situation. There is a quotation form which has discount field (unbounded) that subtracting its value from total amount field (bounded). My question is that how to show that discount field in report view. Many thanx in advance. |
#2
|
|||
|
|||
Showing Unbound fields in form to report.
If the form is sill open , try
=[Forms]![FormName]![TextBoxName] -- Good Luck BS"D "Sohn" wrote: Hi, Is there anyway to display some unbound fields in a form to report? To be more specific, this is the situation. There is a quotation form which has discount field (unbounded) that subtracting its value from total amount field (bounded). My question is that how to show that discount field in report view. Many thanx in advance. |
#3
|
|||
|
|||
Showing Unbound fields in form to report.
Dear Mr.Cohen, I have placed following to control source for the report field in report, but it returns #Name? value. =[Forms]![FormName]![TextBoxName] Would you mind to tell me where I made mistake? |
#4
|
|||
|
|||
Showing Unbound fields in form to report.
I would expect that your first mistake was not providing the form and control
name. This limited Ofer's reply to made up form and control names that you should have replaced with your actual form and control name. -- Duane Hookom Microsoft Access MVP "Sohn" wrote: Dear Mr.Cohen, I have placed following to control source for the report field in report, but it returns #Name? value. =[Forms]![FormName]![TextBoxName] Would you mind to tell me where I made mistake? |
#5
|
|||
|
|||
Showing Unbound fields in form to report.
Dear Mr.Hookom, I didn't use the exact expression but my form name, and textbox name, but it returned #Name?. I double checked whether the form is loaded, but the form is opened. Thank you so much for your help. "Duane Hookom" wrote: I would expect that your first mistake was not providing the form and control name. This limited Ofer's reply to made up form and control names that you should have replaced with your actual form and control name. -- Duane Hookom Microsoft Access MVP "Sohn" wrote: Dear Mr.Cohen, I have placed following to control source for the report field in report, but it returns #Name? value. =[Forms]![FormName]![TextBoxName] Would you mind to tell me where I made mistake? |
#6
|
|||
|
|||
Showing Unbound fields in form to report.
Would make a different if you posted what you wrote, we can't see what
possible mistake you made, like Missing equal sign from =[Forms]![FormName]![TextBoxName] will give an #Name error Or, writing Form instead of forms -- Good Luck BS"D "Sohn" wrote: Dear Mr.Hookom, I didn't use the exact expression but my form name, and textbox name, but it returned #Name?. I double checked whether the form is loaded, but the form is opened. Thank you so much for your help. "Duane Hookom" wrote: I would expect that your first mistake was not providing the form and control name. This limited Ofer's reply to made up form and control names that you should have replaced with your actual form and control name. -- Duane Hookom Microsoft Access MVP "Sohn" wrote: Dear Mr.Cohen, I have placed following to control source for the report field in report, but it returns #Name? value. =[Forms]![FormName]![TextBoxName] Would you mind to tell me where I made mistake? |
#7
|
|||
|
|||
Showing Unbound fields in form to report.
Could you provide the exact expression you used? Did you use the expression
builder to enter the expression? -- Duane Hookom Microsoft Access MVP "Sohn" wrote: Dear Mr.Hookom, I didn't use the exact expression but my form name, and textbox name, but it returned #Name?. I double checked whether the form is loaded, but the form is opened. Thank you so much for your help. "Duane Hookom" wrote: I would expect that your first mistake was not providing the form and control name. This limited Ofer's reply to made up form and control names that you should have replaced with your actual form and control name. -- Duane Hookom Microsoft Access MVP "Sohn" wrote: Dear Mr.Cohen, I have placed following to control source for the report field in report, but it returns #Name? value. =[Forms]![FormName]![TextBoxName] Would you mind to tell me where I made mistake? |
#8
|
|||
|
|||
Showing Unbound fields in form to report.
I am sorry not to be cleared. Here is the situation There is an unbounded discount field in form "frm_invoice_detail" I have put "discount" textbox in my report, rpt_invoice. In the textbox, I directed the control source as following: =[forms]![frm_invoice_detail]![discount] I hope this describe my problem. Many thanx. "Ofer Cohen" wrote: Would make a different if you posted what you wrote, we can't see what possible mistake you made, like Missing equal sign from =[Forms]![FormName]![TextBoxName] will give an #Name error Or, writing Form instead of forms -- Good Luck BS"D "Sohn" wrote: Dear Mr.Hookom, I didn't use the exact expression but my form name, and textbox name, but it returned #Name?. I double checked whether the form is loaded, but the form is opened. Thank you so much for your help. "Duane Hookom" wrote: I would expect that your first mistake was not providing the form and control name. This limited Ofer's reply to made up form and control names that you should have replaced with your actual form and control name. -- Duane Hookom Microsoft Access MVP "Sohn" wrote: Dear Mr.Cohen, I have placed following to control source for the report field in report, but it returns #Name? value. =[Forms]![FormName]![TextBoxName] Would you mind to tell me where I made mistake? |
#9
|
|||
|
|||
Showing Unbound fields in form to report.
The other cause of an error like this is if the control name is also the name
of a field. Is there a reason why you need to create a report that depends on pulling data from a form control? Something like this generally relies on values from records in a table, not a value from a form control. -- Duane Hookom Microsoft Access MVP "Sohn" wrote: I am sorry not to be cleared. Here is the situation There is an unbounded discount field in form "frm_invoice_detail" I have put "discount" textbox in my report, rpt_invoice. In the textbox, I directed the control source as following: =[forms]![frm_invoice_detail]![discount] I hope this describe my problem. Many thanx. "Ofer Cohen" wrote: Would make a different if you posted what you wrote, we can't see what possible mistake you made, like Missing equal sign from =[Forms]![FormName]![TextBoxName] will give an #Name error Or, writing Form instead of forms -- Good Luck BS"D "Sohn" wrote: Dear Mr.Hookom, I didn't use the exact expression but my form name, and textbox name, but it returned #Name?. I double checked whether the form is loaded, but the form is opened. Thank you so much for your help. "Duane Hookom" wrote: I would expect that your first mistake was not providing the form and control name. This limited Ofer's reply to made up form and control names that you should have replaced with your actual form and control name. -- Duane Hookom Microsoft Access MVP "Sohn" wrote: Dear Mr.Cohen, I have placed following to control source for the report field in report, but it returns #Name? value. =[Forms]![FormName]![TextBoxName] Would you mind to tell me where I made mistake? |
Thread Tools | |
Display Modes | |
|
|