I just can't figure it out!

[steve728]

Please help me Cyber Buddies!

What used to work with DAO does not work now with ADO.
I want to use ADO from now on.

I have a form that has a backend query as the recordsource.
I filter the record I want by calling a function (i.e. GetPOnum())
to retrieve a value in a public mem var. The form displays absolutely nothing because of not recognizing the recordsource.
I go into the form's design view and display the backend query to dataview and there is the record I want filtered! I even use msgbox to confirm the the GetPOnum() returning the correct value. It is. If I go into design mode and then return to form view I still get a completely blank screen.

The form works perfectly if I enter the specific PO# in the query's criteria box. What do I do?????

I'm desperate!

Steve

 

[steve728]

If I go to the Records menu and choose Remove Filter / Sort while the form is displaying blank, the form immediately display perfectly! Does this help? Is there a way to toggle the
above menu item with code or is there a better way.

Thank you in advance.

Steve