No expression builder in Access 2007 ADP form

[Allen_N]

I was fairly running with Access 2003, but since Office 2007 was forced upon
me I'm back to crawling.

I've been trying to build a form (in an ADP project) that summarises data
from various tables on the SQL Server. I created a blank form and added text
boxes to show the rresults. When I select a text box, there is no Expression
Builder button in the Control Source field of the Properties drop-down; I
can't get the thing to accept my SQL, either.

Setting the Record Source of the form to the required column makes no
difference.

I know I'm rusty, but Access 2007 seems a lot harder to work with than 2003,
and Help is profoundly unhelpful. (What happened to 'context-sensitive',
Microsoft ?)

Am I missing an important step?

Any advice will be gratefully received.

- Al

 

[Allen_N]

Thanks, AccessVandal.

Does this mean I'm confusin features between MDB and ADP ?

(N.B. The Help topic that came up goes on about the expression builder, but
I didn't see any mentioin that it is restricted to MDB's.)

 

[Allen_N]

Thanks, AccessVandal.

Does this mean I'm confusin features between MDB and ADP ?

(N.B. The Help topic that came up goes on about the expression builder, but
I didn't see any mentioin that it is restricted to MDB's.)