print current record

[Danny]

Hi,

I have a main form (frmHousehold) and a subform (sfrmApplicants).
In my subform I have a field called #OfApplicants which will count the number of Applicants in the subform (in the subform I have a hidden control) which works fine. However, I created (PrintRecord) button in the main form to print the current record and I noticed on the print out that:

1. #Name? shows for #OfApplicants field

2. The Date & page number appears right underneath the
subform as suppose to at the bottom of the page

3. Is there a way to preview how the current record looks like?
printing it?

Any help would be greatly appreciated!

OCM

 

[soundsfishy]

Its sounds to me like #OfApplicants isnt bound correctly. Go into the properties if the unbound field in the report and change the control source to the correct one.