Stored Procedures to get External Objects

[paulgenga]

After upsizing to Adp from mdb I have not been able to use this command to get external obects from my Forms...

Forms![Client Form]![Fieldx]

Please assist

 

[TimKThailand]

Is this a query-by-form? What object do you use this for, a form record source, list box or combo box?

ADP does not support the QBF the way you used to.
To optimize SQL Server perfomance, you have to use stored procedures or views.

Elaborate more about your problem so we can discuss further.

 

[paulgenga]

Hi Tim;
It is a query-by-form to a refreshed list-box based on the current record of the same form
I'm trying to use the View or than SP's.

My idea is to enable me have the list box control have only the relevant records for the picking from a Table

Please Help

 

[TimKThailand]

Check this

http://support.microsoft.com/default.aspx?scid=kb;en-us;q281870

out.

 

[paulgenga]

Thank you a great deal.
I believe the answer to my problem lie here.
Will get intouch as soon as I solve it

Paul