Wrong Field Data in Report

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

Guest

What am I missing?
I fill out a form with combo boxes. After much help through this forum, all
works well. I then created a wizard REPORT but the columns display the wrong
information. For example: IDREPORT is based on IDQUERY (also displaying
wrong info), based on table RECORDINGS (filled in using CDFORM). Combo box
displays ComposerName (not the key field), but the query and report display
the ComposerUniqueID instead. I seem feebly unable to get the right field to
display in the query and report.
 
Make sure the text field that you want to see in your report is in the
report's record source/query.
 
Duane: Thank you for replying.
In the REPORT, each field's property seems to contain the correct CONTROL
SOURCE (i.e. the field name 'Composer' from the table 'Recordings'). The
REPORT is based on a QUERY ('IDQuery' based on the table 'Recordings') which
I set up manually and each field seems to be correct, but both the QUERY and
the REPORT still display the record's 'Unique ID' number instead of the
'ComposerName' field. The FORM for the table 'Recordings' dispays the
'ComposerName' accurately.
PS - using Access2000
 
Back
Top