Parameter issue

  • Thread starter Thread starter Loretta
  • Start date Start date
L

Loretta

I just started a new job where I use an Access database that was already set
up. I have very little experience with the program (only data entry, really).
I hadn't worked with it in a while and forgot how important column headings
in the table were. I abbreviated several long column headings. After I had
saved, I tried to run a report and was prompted for a parameter I had never
been asked for before: CURRENT REVISION (one of my column headings). If I do
NOT respond to the new parameter request, I get a blank report. If I DO
respond, instead of the single page I expect with the current revision
information, I get that PLUS a page for every previous revision. I did go
back and return the column headings to their previous states, I think, but it
did not solve my problem. I also changed some column widths, and tried to
clean up the formatting on some of the reports. I didn't monkey with anything
but the table & reports. I didn't even go into the Queries. I need to get
this fixed. Nobody else at my new job uses the program in that capacity and
no one seems to know how to fix it!! Help!
 
The symptom you described indicates probably a change in the name of a field.
A "column name" will default to the Field Name if you do not give it any
other data to use in the Caption property of the table. Your report has a
RecordSource in the data tab of the properties sheet for the report. OPen
the REcordSource and look for the CURRENT REVISION field. Something has
changed with this field.
 
Back
Top