Report says can't find field

[Gash13]

I made a report with the report wizard. The field is displayed in the wizard and the drop down of the control source. I get an error "Can't find the field". It says the field might have been deleted or misspelled, but it is right there in plain view.


Any idea?

 

[jebry]

Hi!

I assume you have checked the spelling. Have you checked to make sure that you didn't leave out a space or add an extra space? Did you try just selecting the field from the drop-down box?

hth
Jeff Bridgham
bridgham@purdue.edu

 

[benwah]

where r u trying to grab the data from? For example if it is trying to grab the data from an active form but the required form isnt active then u will get that message...

 

[Gash13]

I pulled it from a query. I have other forms pulling it from the same query throughout the database. They all see it and pull it fine. Reports on the other hand give me the error. Yes, I've tried selecting it from the drop down box. (And the report wizard) -- Same error. I even deleted and redid the query. I ended up deleting the field in the table adding a new one with a different name, and it works fine. Confusing,.... the field name was "parent" now it is "guardian"

thanks...