#Name? in paramter text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a report based on a query that has a form as a parameter. When the
report opens it correctly requests the parameter, however the text box
displaying the parameter on the report displays as #Name?

The query has the fiollowing code for the TRANSDATE parameter:

Between [Forms]![Labour Analysis Parameter]![StartDate] And [Forms]![Labour
Analysis Parameter]![EndDate]

In the report header the code for the textbox is:

=[Forms]![Labour Analysis Parameter]![StartDate]
& second text box
=[Forms]![Labour Analysis Parameter]![EndDate]

Both display as #Name?

Is there something very basic that I am doing wrong, I suspect that there is.
 
If the references are exactly the same and are in the control source of the
textbox, then I would examine the names of the textbox controls on the
report. Try changing the names of the textbox controls to something
non-descript like txtMyStart and txtMyEnd.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
I have tried what you have suggested and the #Name? is still appearing.
--
K Hogwood-Thompson


John Spencer said:
If the references are exactly the same and are in the control source of the
textbox, then I would examine the names of the textbox controls on the
report. Try changing the names of the textbox controls to something
non-descript like txtMyStart and txtMyEnd.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

KHogwood-Thompson said:
Hi,

I have a report based on a query that has a form as a parameter. When the
report opens it correctly requests the parameter, however the text box
displaying the parameter on the report displays as #Name?

The query has the fiollowing code for the TRANSDATE parameter:

Between [Forms]![Labour Analysis Parameter]![StartDate] And
[Forms]![Labour
Analysis Parameter]![EndDate]

In the report header the code for the textbox is:

=[Forms]![Labour Analysis Parameter]![StartDate]
& second text box
=[Forms]![Labour Analysis Parameter]![EndDate]

Both display as #Name?

Is there something very basic that I am doing wrong, I suspect that there
is.
Click to expand...
Click to expand...
 
Are you using code anywhere that closes the form?

--
Duane Hookom
Microsoft Access MVP


KHogwood-Thompson said:
I have tried what you have suggested and the #Name? is still appearing.
--
K Hogwood-Thompson


John Spencer said:
If the references are exactly the same and are in the control source of the
textbox, then I would examine the names of the textbox controls on the
report. Try changing the names of the textbox controls to something
non-descript like txtMyStart and txtMyEnd.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

KHogwood-Thompson said:
Hi,

I have a report based on a query that has a form as a parameter. When the
report opens it correctly requests the parameter, however the text box
displaying the parameter on the report displays as #Name?

The query has the fiollowing code for the TRANSDATE parameter:

Between [Forms]![Labour Analysis Parameter]![StartDate] And
[Forms]![Labour
Analysis Parameter]![EndDate]

In the report header the code for the textbox is:

=[Forms]![Labour Analysis Parameter]![StartDate]
& second text box
=[Forms]![Labour Analysis Parameter]![EndDate]

Both display as #Name?

Is there something very basic that I am doing wrong, I suspect that there
is.
Click to expand...
Click to expand...
Click to expand...
 
The form itself does not open when the report is opened

That is obviously the problem isn't it?

There is no code on the form.
--
K Hogwood-Thompson


Duane Hookom said:
Are you using code anywhere that closes the form?

--
Duane Hookom
Microsoft Access MVP


KHogwood-Thompson said:
I have tried what you have suggested and the #Name? is still appearing.
--
K Hogwood-Thompson


John Spencer said:
If the references are exactly the same and are in the control source of the
textbox, then I would examine the names of the textbox controls on the
report. Try changing the names of the textbox controls to something
non-descript like txtMyStart and txtMyEnd.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

message Hi,

I have a report based on a query that has a form as a parameter. When the
report opens it correctly requests the parameter, however the text box
displaying the parameter on the report displays as #Name?

The query has the fiollowing code for the TRANSDATE parameter:

Between [Forms]![Labour Analysis Parameter]![StartDate] And
[Forms]![Labour
Analysis Parameter]![EndDate]

In the report header the code for the textbox is:

=[Forms]![Labour Analysis Parameter]![StartDate]
& second text box
=[Forms]![Labour Analysis Parameter]![EndDate]

Both display as #Name?

Is there something very basic that I am doing wrong, I suspect that there
is.
Click to expand...
Click to expand...
Click to expand...
 
The form needs to be open.

--
Duane Hookom
Microsoft Access MVP


KHogwood-Thompson said:
The form itself does not open when the report is opened

That is obviously the problem isn't it?

There is no code on the form.
--
K Hogwood-Thompson


Duane Hookom said:
Are you using code anywhere that closes the form?

--
Duane Hookom
Microsoft Access MVP


KHogwood-Thompson said:
I have tried what you have suggested and the #Name? is still appearing.
--
K Hogwood-Thompson


:

If the references are exactly the same and are in the control source of the
textbox, then I would examine the names of the textbox controls on the
report. Try changing the names of the textbox controls to something
non-descript like txtMyStart and txtMyEnd.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

message Hi,

I have a report based on a query that has a form as a parameter. When the
report opens it correctly requests the parameter, however the text box
displaying the parameter on the report displays as #Name?

The query has the fiollowing code for the TRANSDATE parameter:

Between [Forms]![Labour Analysis Parameter]![StartDate] And
[Forms]![Labour
Analysis Parameter]![EndDate]

In the report header the code for the textbox is:

=[Forms]![Labour Analysis Parameter]![StartDate]
& second text box
=[Forms]![Labour Analysis Parameter]![EndDate]

Both display as #Name?

Is there something very basic that I am doing wrong, I suspect that there
is.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top