B
bruceMS
I'm really stumped by this problem...
I created a Form1 with Query1 and the OrderBy was set to Date1, I presume
because Query1 had such a sort.
I added to Form1 a subForm, Form2, with:
LinkMasterFields = LNameH
LinkChildFields = LName
and it worked fine.
I decided to change the OrderBy for Form1 to LNameH. When I made the
change, the subForm would not display any records. I change OrderBy
back to Date1, and it works.
I changed Query1's Orderby to LNameH, but it had no affect.
I tried to create a new form, but I'm coming up with the same result.
What am I missing here? Is there something else I need to be looking at?
I created a Form1 with Query1 and the OrderBy was set to Date1, I presume
because Query1 had such a sort.
I added to Form1 a subForm, Form2, with:
LinkMasterFields = LNameH
LinkChildFields = LName
and it worked fine.
I decided to change the OrderBy for Form1 to LNameH. When I made the
change, the subForm would not display any records. I change OrderBy
back to Date1, and it works.
I changed Query1's Orderby to LNameH, but it had no affect.
I tried to create a new form, but I'm coming up with the same result.
What am I missing here? Is there something else I need to be looking at?