Adding a subform

  • Thread starter zaps via AccessMonster.com
  • Start date
Z

zaps via AccessMonster.com

Hi Everybody,
I need some help adding a subform into my form. I have a form for data entry
called "frmDetails' and I also have a form called "frmWhatDates". The "what
dates" form limits a report to a date range ( From Start date to End date).
I would like to add this from into the bigger Details form, that way users
can enter their data and then be able to run a report within a specific date
range. I tried using the subform wizard, and calling the subform the same as
the form "frmWhatDates". Is that right?? The form works fine on it's own.
When I add it into the Details form as a subform, on the report the dates
shows ?Name. (I have 2 text boxes in the report, controlSource set to:
=Forms.frmWhatDates.txtStartDate and the other =Forms.frm.WhatDates.
txtEndDate)

Oooh, hope that makes sense. Any help is greatly, greatly appreciated!

Thanks,
Zaps
 
Top