Subforms blank when pointing at link tables

[gellerche]

I have subforms that are fine when their record source is a table on my hard drive. However, if I change the record source to link tables on the server, the entire subform is blank. I don't mean the individual controls in the subform are blank, I mean the entire subform is one solid color with no visible controls or data. The tables on my hard drive have the same structure and data as the link tables from the server. Does anyone know why this is happening?

Thank you for your help,


Steve Geller

 

[Pat Hartman]

Verify the master/child links. Open the queries and make sure that they are retrieving data.

Subforms will appear totally blank when there is no data to show and allowAdditions is set to no.