linking report and form

H

heg

I have a simple database that has a data entry form and a
report that will print the data entered for one record
from the form. In the report's properties I have [Date]=
[Forms]![frmBriefingRecord]![Date] and FilterOn is set to
Yes. A command button on the report starts a macro that
opens the report in print preview. The Where Condition is
the same as the above filter.

Whenever a user clicks the command button a parameter
window appears asking for "[Forms]![frmBriefingRecord]!
[Date]". Why? I have checked the form name and the control
name. Both are correct. Another database I wrote uses the
same mechanism for opening a report to the requested
record. Why am I having this trouble with this one. Is it
because the linking control does not refer to a primary
key value (in the other DB, it does)?
 
Top