Controlling dates on 3 subforms

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Hi,

I have 4 tables, tblProgrammes, tblProgrammeUpdates,
tblCalendarOfEvents & tblIssues.
Each table has a common ProgrammeID field and date field.
I have produced a main form (tblProgrammes) with the 3
linked subforms to show the updates, events and issues for
each Programme.
This works well but my problem is that I have now been
asked to show updates, events and issues by dates -
presently they show eveything for each Programme.
How do I go about controlling the display of dates on the
3 subforms.

Thanks in advance
Tony
 
Tony

If I understand your description, it sounds like you could use the
parent/child linking fields in the subform control to specify both
ProgrammeID and YourDate fields as the common fields.
 
Jeff,

Thanks for you reply.
Pretty ok with Access 2000 but I've never used
parent/child linking fields to link more than 1 field.
How do I do this.
Currently they look like this...

Link Child Fields ProgrammeID
Link Master Fileds ProgrammeID

Also, would this work for example if I wanted to display
all events, issues and updated say for March 2004?

Thanks

Tony
 
Tony

Take a look in Access HELP for one of these (e.g., Link Master Fields). I
don't recall exactly, but suspect you separate multiple fields with a
semi-colon.
 
Back
Top