When debug.print is working, does it look any different than the usual yellow highlight?
Yes, it prints your variable/expression to the immediate window.
This extract of vba code
Code:
.......
For Each rel In db.Relations
180 Debug.Print vbCrLf & "RELATION NAME :" & rel.name & vbCrLf & vbTab & vbTab & "FROM TABLENAME: " & rel.Table & " TO TABLENAME: " & rel.ForeignTable ', rel.Attributes"
190 For Each fld In rel.Fields
200 Debug.Print vbTab & vbTab & vbTab & " FieldName: " & fld.name & " ForeignFieldName: " & fld.ForeignName
210 Next fld
220 Next rel
..........
Results in output like this in the immediate window.
Code:
RELATION NAME :tblAgencyContactstblAgency
FROM TABLENAME: tblAgencyContacts TO TABLENAME: tblAgency
FieldName: ContactID ForeignFieldName: PrimeContactFK
RELATION NAME :tblAgencytblAgencyContacts
FROM TABLENAME: tblAgency TO TABLENAME: tblAgencyContacts
FieldName: AgencyID ForeignFieldName: AgencyIDFK