Showing Unbound fields in form to report.

[Sohn]

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.

 

[Ofer Cohen]

If the form is sill open , try

=[Forms]![FormName]![TextBoxName]

 

[Sohn]

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?

 

[Duane Hookom]

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.

 

[Sohn]

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.

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

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?

 

[Ofer Cohen]

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

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.

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

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?

 

[Duane Hookom]

Could you provide the exact expression you used? Did you use the expression
builder to enter the expression?
--
Duane Hookom
Microsoft Access MVP

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.

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

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?

 

[Sohn]

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.

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

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.

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


:


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?

 

[Duane Hookom]

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

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.

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

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.

:

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


:


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?