By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,746 Members | 1,608 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,746 IT Pros & Developers. It's quick & easy.

Link Master / Link Child subform query

P: 5
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.
Mar 24 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.