Vba Query --> Form?

[CJBIRKIN]

Hello
I am rapidly coming to the point where i need to do more complex queries than can suitably be handled using the QBE. What i need to know is how to link a query written in VBA to a form. Does anyone have a simple example??

Cheers

Chris

 

[Tim K.]

You want to show the records based on your VBA SQL? Try this.

...
Dim strSQL

strSQL =" ......"
...
Me.RecordSource = strSQL

 

[CJBIRKIN]

Hello

Who'd guess life could be so simple!!.

Thanks v.much

Chris