Empty subform

  • Thread starter Thread starter Jonathan Blitz
  • Start date Start date
J

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."
 
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?
 
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."
 
Back
Top