MontyBurns
Programmer
Hi,
I haven't been using Access for a few months so I imagine what i'm asking is really basic, but I can't seem to figure it out all the same.
I have a main form with a subform, and also a separate filter form. The filter form opens the main form with a filter based on the subform (maybe the filter query will explain better):
TopicId IN
(
SELECT TopicID
FROM tblTopicsToFiles
WHERE FileNo=xx
)
So i'm opening the main form and showing only those records which have the selected record in it's subform.
Problem is that the subform is not showing any records, even though I know it should. I've tried requerying the subform, but it doesn't seem to make any difference. I've also made sure the child and master fields are ok.
I'm using Access 2k on W2k.
Any help or pointers would be really appreciated.
Thanks,
Burns
I haven't been using Access for a few months so I imagine what i'm asking is really basic, but I can't seem to figure it out all the same.
I have a main form with a subform, and also a separate filter form. The filter form opens the main form with a filter based on the subform (maybe the filter query will explain better):
TopicId IN
(
SELECT TopicID
FROM tblTopicsToFiles
WHERE FileNo=xx
)
So i'm opening the main form and showing only those records which have the selected record in it's subform.
Problem is that the subform is not showing any records, even though I know it should. I've tried requerying the subform, but it doesn't seem to make any difference. I've also made sure the child and master fields are ok.
I'm using Access 2k on W2k.
Any help or pointers would be really appreciated.
Thanks,
Burns