What have I done wrong!

#1 (**permalink**) 28-Jul-2006, 08:19 AM

Added a new Field to my Table, Put a text box on the form, all good, then
tried to add a text box to the Report linked the that field, But now when I
try to open the Report I get this error
Enter parameter Value and below my field BottomTaxLabel

Thanks in advance.........Bob Vance

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11200-what-have-i-done-wrong.html

*

#2 (**permalink**) 28-Jul-2006, 08:19 AM

Bob,

First two things to check:
- did you spell the name of the field exactly correctly when put on
the report?
- is the report based on a query, rather than directly on the table,
in which case the field will have to be included in the query?

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11200
--
Steve Schapel, Microsoft Access MVP

Bob wrote:
> Added a new Field to my Table, Put a text box on the form, all good, then
> tried to add a text box to the Report linked the that field, But now when I
> try to open the Report I get this error
> Enter parameter Value and below my field BottomTaxLabel
>
> Thanks in advance.........Bob Vance
>
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11200

#3 (**permalink**) 28-Jul-2006, 08:19 AM

=tblCompanyInfo!BottomTaxLabel
this what happened after I tried to enter through Source Control...Regards
Bob

"Bob" wrote in message news:e6fqcd$7tu$1@lust.ihug.co.nz...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11200
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11200
>
>
> Added a new Field to my Table, Put a text box on the form, all good, then
> tried to add a text box to the Report linked the that field, But now when
> I try to open the Report I get this error
> Enter parameter Value and below my field BottomTaxLabel
>
> Thanks in advance.........Bob Vance
>

#4 (**permalink**) 28-Jul-2006, 08:19 AM

Bob,

If your field is named BottomTaxLabel, then the textbox on your report
should have its Control Source property set as BottomTaxLabel. The Name
property of the textbox can also be BottomTaxLabel, in fact that's what
I would do, but doesn't need to be. But as I mentioned before, for this
to work the BottomTaxLabel field will need to be included in the query
or table that the report is based on. This is defined in the Record
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11200
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11200
Source property of the report itself.

--
Steve Schapel, Microsoft Access MVP

Bob wrote:
> Steve on my form should it be a text box or list box?
> It is just for showing what I have entered into another form no more than 50
> letters...Regards Bob
> Should be spelt in Name or Control source window?
>

#5 (**permalink**) 28-Jul-2006, 08:19 AM

Steve I have added another field to the table "CompanyInfo" which is called
"BottomTaxLabel" I have typed GST into the CompanyInfo Form and it shows
GST in the Table of CompanyInfo
I have done what you said but still get the Parameter Value error on my
Report, Checked it with other thing on the report like Ph Numbers and email
address,s which are copied the same from CompanyInfo. Doesn't seem to be any
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11200
Qrys......I will keep trying Thanks Bob

"Steve Schapel" wrote in message
news:O1A444PjGHA.4508@TK2MSFTNGP05.phx.gbl...
> Bob,
>
> If your field is named BottomTaxLabel, then the textbox on your report
> should have its Control Source property set as BottomTaxLabel. The Name
> property of the textbox can also be BottomTaxLabel, in fact that's what I
> would do, but doesn't need to be. But as I mentioned before, for this to
> work the BottomTaxLabel field will need to be included in the query or
> table that the report is based on. This is defined in the Record Source
> property of the report itself.
>
> --
> Steve Schapel, Microsoft Access MVP
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11200
> Bob wrote:
>> Steve on my form should it be a text box or list box?
>> It is just for showing what I have entered into another form no more than
>> 50 letters...Regards Bob
>> Should be spelt in Name or Control source window?
>>

#6 (**permalink**) 28-Jul-2006, 08:19 AM

Well I made a Qry to TaxBottomLabel and the entered a Listbox linked to the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11200
qry and it worked, only way I could get it to work, Is there any way I can
Right Align my List Box on the Report?? Thanx.. Bob

"Bob" wrote in message news:e6fvit$hno$1@lust.ihug.co.nz...
> Steve I have added another field to the table "CompanyInfo" which is
> called "BottomTaxLabel" I have typed GST into the CompanyInfo Form and it
> shows GST in the Table of CompanyInfo
> I have done what you said but still get the Parameter Value error on my
> Report, Checked it with other thing on the report like Ph Numbers and
> email address,s which are copied the same from CompanyInfo. Doesn't seem
> to be any Qrys......I will keep trying Thanks Bob
>
> "Steve Schapel" wrote in message
> news:O1A444PjGHA.4508@TK2MSFTNGP05.phx.gbl...
>> Bob,
>>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11200
>> If your field is named BottomTaxLabel, then the textbox on your report
>> should have its Control Source property set as BottomTaxLabel. The Name
>> property of the textbox can also be BottomTaxLabel, in fact that's what I
>> would do, but doesn't need to be. But as I mentioned before, for this to
>> work the BottomTaxLabel field will need to be included in the query or
>> table that the report is based on. This is defined in the Record Source
>> property of the report itself.
>>
>> --
>> Steve Schapel, Microsoft Access MVP
>>
>> Bob wrote:
>>> Steve on my form should it be a text box or list box?
>>> It is just for showing what I have entered into another form no more
>>> than 50 letters...Regards Bob
>>> Should be spelt in Name or Control source window?
>>>
>
>

#7 (**permalink**) 28-Jul-2006, 08:19 AM

Bob,

What is the Record Source of the Report? (look at the properties of the
report itself, and see the Record Source property).
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11200

--
Steve Schapel, Microsoft Access MVP

Bob wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11200
> Well I made a Qry to TaxBottomLabel and the entered a Listbox linked to the
> qry and it worked, only way I could get it to work, Is there any way I can
> Right Align my List Box on the Report?? Thanx.. Bob

#8 (**permalink**) 28-Jul-2006, 08:19 AM

How do I find the properties of the report?? thanx bob

"Steve Schapel" wrote in message
news:OElIcXQjGHA.4508@TK2MSFTNGP05.phx.gbl...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11200
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11200
> Bob,
>
> What is the Record Source of the Report? (look at the properties of the
> report itself, and see the Record Source property).
>
> --
> Steve Schapel, Microsoft Access MVP
>
> Bob wrote:
>> Well I made a Qry to TaxBottomLabel and the entered a Listbox linked to
>> the qry and it worked, only way I could get it to work, Is there any way
>> I can Right Align my List Box on the Report?? Thanx.. Bob

#9 (**permalink**) 28-Jul-2006, 08:19 AM

Got it "rptInvoiceModify"

"Bob" wrote in message news:e6g5kq$snj$1@lust.ihug.co.nz...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11200
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11200
> How do I find the properties of the report?? thanx bob
>
> "Steve Schapel" wrote in message
> news:OElIcXQjGHA.4508@TK2MSFTNGP05.phx.gbl...
>> Bob,
>>
>> What is the Record Source of the Report? (look at the properties of the
>> report itself, and see the Record Source property).
>>
>> --
>> Steve Schapel, Microsoft Access MVP
>>
>> Bob wrote:
>>> Well I made a Qry to TaxBottomLabel and the entered a Listbox linked to
>>> the qry and it worked, only way I could get it to work, Is there any way
>>> I can Right Align my List Box on the Report?? Thanx.. Bob
>
>