No Results Being Displayed

[mapat]

Hello,
I am using ACCESS 2007.
I have a subformA inside the main form. I have the following 2 buttons: INBOX and SENT on the main form.
The idea is that when clicking on INBOX or SENT the results displayed on subformA should change (looking at different records) depending on which button I click on.

For instance,
The OnClick event of INBOX btn looks like this:
Me.subformA.SourceObject = qryINBOX
where qryINBOX is the following query:
SELECT tMessages.*
FROM tMessages
WHERE INBOX=True;

I use the same criteria for the SENT button, but when clicking on either button subformA shows no results at all. Am I looking at the right property (SourceObject)? Can anyone give me a hand on this?

Thank you very much for the help everyone.

 

[pbaldy]

Given what you're doing, I suspect you want the RecordSource property of the subform:

http://access.mvps.org/access/forms/frm0031.htm

You'd use the SourceObject property to put a different form in the subform control.

 

[mapat]

Given what you're doing, I suspect you want the RecordSource property of the subform:

http://access.mvps.org/access/forms/frm0031.htm

You'd use the SourceObject property to put a different form in the subform control.

Thank you very much for your help. That resolved the issue.

 

[pbaldy]

Happy to help.