Link Master / Link Child subform query

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • 20028431
    New Member
    • May 2009
    • 5

    Link Master / Link Child subform query

    I have a main form called ’frmIssues’ which contains 2 subforms ‘sbfmLog’ and ‘sbfmLogNote’

    frmIssues is bound to table ‘tblIssues’ and has fields IssueId (PK- Autonumber), Title (txt), DateOpened (Date/Time), Category (txt) etc.

    sbfmLog is bound to table ‘tblLog’ and has LogId (PK- Autonumber), LogDate(Date/Time) , LogTime (Date/Time), ActionType (Txt), LogTitle (Txt) and IssueID (FK – Number) which is presented in datasheet view.
    The Link Master Fields = IssueID
    Link Child Fields = IssueID

    sbfmLogNote is also bound to table ‘tblLog’ and has LogID (PK-Autonumber), LogNote (Memo).

    SbfmLog works fine and displays the the relvant logs for issue number but I am having a problem linking the sbfmLogNote. As a user selects a record in the sfrmLog, the sbfmLogNote should populate with the relevant note but this is not working.
    The Link Master Fields = LogId
    Link Child Fields= LogId

    I have also tried using IssueId and a combination of IssueId, LogId. Where am I going wrong?

    Thank you all for reading my post. All help gratefully received.
    ps I am using Access 2007.
Working...