passing data to a query from an inputbox

[stan]

The SQL below worked in Access 95 (V 7) is not working in the current
version (V 2003).

What is supposed to happen:

1) From my form I hit a button that calls an input box.
2) Underlying this form is a query, and the data entered into the input
box is passed to the corresponding field in the query.

When I set up the query, I used "Design View". Here is the SQL that
that was created:

SELECT Properties.OwnerID, Properties.TST, Properties.TSTNUMB,
Owners.COMP, Properties.MLSDIST, Owners.F, Owners.L
FROM Properties INNER JOIN Owners ON Properties.OwnerID =
Owners.OwnerID
WHERE (((Properties.MLSDIST)=InputBox$("«MLS Dist.??»")))
ORDER BY Owners.COMP, Owners.L;

When I run this query in my current version of Access I get this error
message:

"Function is not available in expressions"

With respect to "expressions", in the query grid there is a row
labeled "Totals". In that row, "expressions" self-populates in every
column .

Stan

[Cyberwolf]

Instead of what you did try this

SELECT Properties.OwnerID AS Expr1, Properties.TST AS Expr2,
Properties.TSTNUMB AS Expr3, Owners.COMP AS Expr4, Properties.MLSDIST
AS Expr5, Owners.F AS Expr6, Owners.L AS Expr7
FROM Properties, Owners
WHERE ((([Properties].[MLSDIST])=[MLS Dist.??]))
ORDER BY Owners.COMP, Owners.L;