I am unable to use a parameter field in a query where the external data is linked not imported into the table.

When I try to use a parameter field I get an Error 3349 msg "Numeric Field Overflow." The Help button msg is "Data in Btreive field is too large to represent in your application."

The parameter field works OK when the external data is imported into the table.

Very Strange.

You can create the SQL in code so that Access can parse the variable and the Btrieve ODBC driver will think you are using a literal. Maybe that would work.

Dim txtSQL as String
txtSQL = "Select whatever From whatever Where "
txtSQL = txtSQL & Me.SomeFormField & ";"

Then run the SQL.