New feature! Upgrade and increase expert visibility of your issues with Priority Questions.
Here is how I would browse the value of the field and this works: Dim db As DAO.Database Dim rs As Recordset Dim childRS As Recordset Set db = CurrentDb ' Get Primary RecordSet Note Set rs = db.OpenRecordset("SELECT * FROM Notes WHERE Note_ID = " & Me.Note_ID) rs.MoveFirst Set childRS = rs.Fields("Code").Value childRS.MoveFirst Do Until childRS.EOF MsgBox (childRS.Fields("Value").Value) childRS.MoveNext Loop
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.