Form function stop work when linked to SQL

[gmatriix]

Hello,

I have a Access DB with SQL as the back end. I have some simple calculations in the form that work when it is not connected to SQL but does not work when connected. Example:

I have a subform in this form. Is uses "=[RoutingSubform].[Form]![costpcsum]" to display some data from the subform. Now it gives me "#Name?"

Do I need to format this differently since its coming from SQL? The same is happening with some event procedures I have tied to some buttons.

Any Ideas?

Thanks!

 

[sxschech]

Not sure if this will work in your situation, what if you try basing your form off another query...

SELECT *
FROM LINKEDSQLNAME

use the actual linked name for LINKEDSQLNAME

 

[gmatriix]

I will try with a query and see if that makes a difference....

Thanks