Report asking for parameter value after change

[DougM]

I have a report (lets call is Assets by Suppliers), that was originally called (Assets by Vendor), In the report I have changed everything over from vendor to supplier, I have fixed all tables, forms, etc.

Before the changes the report would just open up and display all assets, but after the change it pops up a window stating "enter parmeter. VendorID". I have spent days trying to find out where this vendorId is located so that I can change it. Silly me if i had just opened my eyes.

In the report design view the report is broken into

Report Header
Page Header
*VENDORID HEADER*
Detail
*VENDORID Footer*
Page Footer
Report Footer

(I am guessing the these references to vendorId are the culprits)

so now I see where the VendorID is located, ok
But when I try to change it no go..all I see when I double click the little grey box to the left of the header and footer are

For VendorID Header

Name......GroupHeader0
ForceNew Page....None
New Row or Col....None
Keep Together.... Yes
Visible................Yes
Can Grow...........No
Can Shrink.........No
Repeat Section....No
Height.............0.625"
Back Color.......16777215
Special Effect......Flat
Tag..................Blank
On Format........Blank
On Print............Blank
On Retreat........Blank

For the VendorID Footer I have

Name...............GroupFooter1
Force New Page........None
New Row Or Col........None
Keep Together..........None
Visible.....................Yes
Can Grow..................No
Can Shrink................No
Height.......................0.4167"
Back Color..............16777215
Special Effect.............Flat
Tag..........................Blank
On Format................Blank
On Print....................BLank
On Retreat...............Blank

There is nothing hear for me to change from vendorid to supplierid...Where is it buried?
I have opend the MS Visual Basic window and done a Project search for Vendor, VendorID, GroupFooter1, GroupHeader0. And found nothing, nothing at all.

Please Please does anyone know what to do to fix this.
I think it is something simple (i mean i can't see ms thinking you would never have to change a report/table specific head/footer) but so far I am going batty trying to get this to work.

Doug

 

[DALeffler]

Left click once on the control that's in the header section. Then change the Control Source property to SupplierID.

Do you have any code behind that report? You might have to change that too...

 

[DougM]

The header titled

VendorID Header
has 1 control (which I have changed from VendorName to SupplierName)
and 6 labels

what i think i need to do is to get the header title to change from VendorID Header to Supplier ID header...I have gone thru everything in VB, and all, and can figure out how to change that damn header name. the header itself when double clicked for properties comes up with a name GroupHeader0..and nothing to really change (as listed above)


Any more ideas???
I can zip up the db, and upload it (if someone will tell me how)..it is a pretty basic thing. I have just taken 2 different db from microsoft and combined them, and made a few symatic changes. all that is left to fix are about 4 reports that are doing this same problem.

Doug

 

[DALeffler]

What does Sorting and Grouping (under the Veiw menu item) for the section say?

Try changing those field names to the new field names.

 

[DougM]

OH hot damn!!!

That was the ticket!

Thank you, thank you..

you do not know how much this has been killing me!

Thanks!!!!!