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.