My subdatasheet shows the column headings but none of the data

[Guest]

The relationship between the 2 table's fields looks fine.
all the headings from the child table display.
I have deleted and reset this subdatasheet now several times.
Please HELP.

 

[Guest]

First, verify that you can see the data from the tables involved, when you
create a query. This will help rule out any foreign key related issues.

If you can produce a query that displays the expected records, then start
looking closely at your Link Master Field / Link Child Field properties of
the control that holds the subform. I suspect you misspelled one of these.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________