I have an ADP database linked to SQL7. I have done a lookup on a form which provides information for a client on the key field [AccountNo].
I want to open a report filtered on the [AccountNo].value that is on the form, but as I am new to ADO, I can't find an easy way to do it.
I have gone round in circles with ServerFilter, InputParameter and even trying to write a reference to the form in SQL (which doesn't work as it would in an MDB query).

I am embarrased to say that I can't figure out how to do this, and it's probably simple. (I hope).

Regards
Adrian

With the help of Allen Browne MVP, the solution is at hand. It is possible to get the information by putting:-

Me.ServerFilter = (("[SomeField] = '" & [Forms]![OpenForm]![FieldIWant] & "'"))

onto the reports onopen property

Note:- The above is for values that do not contain an apostrophe. If your field may contain an apostrophe, then you will need to use a different format (See Access 2000 Developers handbook Vol 1, page 285)

Thanks again Allen.

Regards

Adrian