Query result doesn't show in subform but...

[silviana.lim]

Hi all,

I'm Silvi and I'm really dummy in Access.
I have this simple project and learn from internet.
So far I already success to run this dynamic query where the parameters taken from the main form.
Now the problem is the query result doesn't show in the subform.
But the status bar below tell me that it have 2 records in the subform, but there is no data in the subform, it just Blank.

I already apllied the Requery or Refresh to the subform (in the Command Button), but it have no result too.
This is the code:

Forms!MsDataWarga.QueryDataWarga.Form.RecordSource = "MyQuery"
Forms!MsDataWarga.QueryDataWarga.Requery
Forms!MsDataWarga.QueryDataWarga.Refresh

Can anyone help me what happen here? and what should I do to show this data?

Sorry if my english is bad, hope this print screen can explain more than my text above.
Here I attach the print screen...

Thanks for all...

Silvi
Indonesia

 

[JHB]

Did you change the font colour for subform to white, (else post you database with some sample data)?

 

[silviana.lim]

hi JHB,

thank you for your response.
i will recheck it ASAP.
and reply you for the result.

 

[silviana.lim]

JHB,

I already recheck my subform.
It's Background Color is White (#FFFFFF) and the Alternate Backcolor is No Color.
I think it's not the problem...

Maybe you can suggest me anything else...?

Thank you JHB

 

[JHB]

JHB,

I already recheck my subform.
It's Background Color is White (#FFFFFF) and the Alternate Backcolor is No Color.
I think it's not the problem...

Maybe you can suggest me anything else...?

Thank you JHB

Hmm - I asked for the font colour! Post your database with some sample data, (zip it).