calendar control not working

  • Thread starter Mitchell_Collen via AccessMonster.com
  • Start date
M

Mitchell_Collen via AccessMonster.com

I have a calendar control and want the calendar value to cause a subform to
display data from a table filtered only be the calendar date picked by user.
I have set the subform child link equal to orderDate from the table and the
parent link to [calendar0] however when the form is ran the subform does not
display anything. Can you tell me what it is that I have missed?

Thanks, Mitchell
 
S

strive4peace

Hi Mitchell,

"equal to orderDate from the table"

the LinkChildFields refers to CONTROL NAME(s) -- so you must put the
orderDate on the subform (even if you make it not Visible) and use the
Name of that control for LinkChildfields

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

setting filter on a subform from a calendar control 1
variable subform values 1
Update Subform Based on Calendar Control 1
Lebans Calendar & Subforms 4
How do I put a calendar control onto a subform? 1
Display Child Records in subform 7
Excel Worksheet_BeforeDelete code not working as expected. 1
Suform not linking 11

Top