how to populate data in subform?

[jwala]

I have 3 inputs based on which i'll fetch records from table in a subform for the given input criteria. Please let me know how to populate subform programmatically?

I tried source object property and form.recordsource property. It gives me some error or the other. let me know the right syntax to do the above mentioned.

Thanks in advance,
jwala

 

[gromit]

Hi -

You can set the RecordSource property programmtically with a valid SQL string. E.g.

Me.RecordSource = "SELECT * FROM tblData WHERE DateEntered > #1/1/2000# "

You can test the SQL string in a query to see that it is working correctly as part of your debugging.

Hope that helps,

- g