Form with Calandar Control / Record Link

jasonp21

New member
Local time
Yesterday, 19:44
Joined
Dec 9, 2011
Messages
8
Hi, I'm trying to get a calandar control in a form link to two record subforms - one with event details (name, time, etc) and another with resources (PC, Projector, etc) so that when you click on a specific date in the calandar, it displays the relevant records in the subforms (so that you can enter a new record, or review existing). I'm using Access 2002. Help would be appreciated!!

With thanks (in anticipation):)

Jason
 
Last edited:
* Type in the name of the Calendar Control into the Link Master Fields property of the subform.
* Type in the name of the subform's Date field into the Link Child Fields property of the subform.

Note that I mentioned type it in, don't click the elipsis button.
 
Thanks. Where do I find the Link Master and Link Child fields? They don't seem to appear in the two subforms properties...
 
Click the subform control ONCE and look in the property sheet. The first click is the subform control, the second subsequent click will take you to the form.
 
I've managed to get the calandar control link to the first subform - containing event details - so now the records change depending what date you click on. However, dispite numerous attempts i'm unable to get the records in the second subform - a equipment dropdown list - to stay linked to the related record in the first subform.

After entering a record in the first subform, and selecting equipment in the second, when i select a different date, even if there are no records in the first subform, the same equipment for the last record entered remains listed. Any suggestions?
 
To link subform1 to subform2 you need to:

1. Drop a textbox on the main form and call it txtLinkSub1
2. Enter the path to the field in subform1 into the Control Source of txtLinkSub1. So the Control Source will look something like:
Code:
=[Forms]![[COLOR=Red]Subform1[/COLOR]]![[COLOR=Red]ID_Field[/COLOR]]
3. Enter txtLinkSub1 into the Link Master Fields property of subform2 and enter the ID field into the Child property. Remember what I mentioned in my first post, don't click the elipsis button, type it in.
 

Users who are viewing this thread

Back
Top Bottom