unexpected/unwanted parameter query

T

Ted

hi,

i'm finding that there's an unexpected parameter query ('Text14') that
appears when i go to run my report. i thought all i need to do was look
through the names of the half dozen or so controls in the details section
until i come across it and then .... but i'm not even finding any reference
to 'Text14'. so where's it coming from and what do i do about it?

any one care to give me a clue--it'd be really appreciated.
 
J

Joan Wild

Ted said:
i'm finding that there's an unexpected parameter query ('Text14') that
appears when i go to run my report. i thought all i need to do was
look through the names of the half dozen or so controls in the
details section until i come across it and then .... but i'm not even
finding any reference to 'Text14'. so where's it coming from and what
do i do about it?
Click to expand...

Check all the control sources of all the textboxes. Check the sorting and
grouping dialog.
 
T

Ted

joan,

there are only half a dozen text boxes and i checked (actually double
checked) the control sources of each (both before and after your post) and
Text14 isn't there.

i seem to recollect having found a control on the form which has a command
button that launches the report with that Text14 name and changing it. but
what could this have to do with the Parameter Query requesting Text14's
value. it didn't act this way prior to the change.

-ted
 
J

Joan Wild

Ted said:
i seem to recollect having found a control on the form which has a
command button that launches the report with that Text14 name and
changing it. but what could this have to do with the Parameter Query
requesting Text14's value. it didn't act this way prior to the change.
Click to expand...

Did you check the sorting and grouping dialog box in report design view?
 
T

Ted

the soluton came to when i recalled having copied and pasted the combobox
control from a form onto a pre-existing repor. the combobox had been added de
novol onto the form earlier and in pasting it onto the report i decided to
change the name from 'Text14' to 'Cycle'. for some reason, it didn't quite
fancy that idea and began requesting values for 'Text14'. on editing 'Cycle'
to 'Text14' the paramter query prompt for it disappeared. i understand that
not populating a form/report from the 'List' of available controls can be
problematic at times.

-ted
 
Top