Empty subform

[Jonathan Blitz]

I have a weird problem.

One of my subforms refuses to show any data even though there is definetly
matching data between the parent and child.

If I remove the child/parent link fields then (of course) I get all the
lines in the subform. As soon as I enter the field names the lines
disappear.
If I perform the select directly in SQL then all works ok.

What could I be missing?

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."

 

[Allen Browne]

What are the names of the fields in the LinkMasterFields and
LinkChildFields? Any chance they could be mistaken for built-in properties
or methods, e.g. Name, Date, Section?

What data type are these fields? Are they the same type? Any possiblity of
floating point errors? Any calculated fields, where Access could
misunderstand the data type?

 

[Jonathan Blitz]

Fields are called Rowid and Matchrowid and are both defined as bigint in
SQL.

There IS a field called "file" in the subform but it seems to be ok because
if I don't put in the link then the subform shows ok.

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."