So you want to display the table fields ID_Formula and Descricao, and also
display (independently of any table value) the contents of the Form textbox
Text110? Is this query the recordsource for the form? What are the contents of
Text110?

Access may be getting confused about the datatype of the textbox, since an
unbound textbox has no defined datatype (unlike a table field). If you want
Text110 to be shown as a number try using

Val(([forms]![18_form_InsereLinhasFcsts]![Text110]) AS teste

            John W. Vinson [MVP]

It’s a bad idea to make us guess on what you’re attempting to do.

My guess is that you’re trying to use the forms and controls to create or
construct a SQL string.

String = “SELECT “ & 11_tbl_Calculos_por_Formulas_Fcsts.ID_Formula & “,” &
11_tbl_Calculos_por_Formulas_Fcsts.Descricao & “,”
& [Forms]![18_form_InsereLinhasFcsts]![Text110] &” AS teste ”
& “FROM “ & 11_tbl_Calculos_por_Formulas_Fcsts & “;”

If the above is not correct, meaning not using VBA. Are you using the
standard query grid? But it appears that you’re not using it.

to

I don't "want" to mean something with "bound" -- what I mean has been Access
terminology since Access 1.0.  That is, a bound form has a Table or Query
shown in its RecordSource property, and fields from that RecordSource are
displayed in Controls (Text Boxes, Combo Boxes, etc.) on the Form.  An
unbound form does not have a Table or Query in its RecordSource property,
and you fill the Controls and update whatever you may want to update with
your own code.  Except for Forms just for controlling or entering
controlling information -- Splash Screens, entering Date Ranges for Reports,
and such -- using unbound forms is not taking avantage of the power of
Access.

Do you mean you have a Control (it'd be useful, maybe, even to know what
kind of control it is) in which the Field, Field1, from the Form's Record
Source is displayed, and that Control has a Default Value of 2?

I don't think you answered my question... _is FormA Open when you execute
the Query_?

showing

nothing

Could you explain not "how you want to accomplish it" (that is, picking up a
value from a Control on a Form) but "what you are trying to accomplish" by
doing so?  I've used Access daily since 1993 and never had a need to do what
you are trying to do.  I've used references to Fields on Forms in the
Criteria, but not in the Value.

Further, I cannot reproduce getting the actual value from the referenced
Control even under the circumstances you described, of using a default value
(which implies opening the Form in DataEntry mode or moving to the new
record position with the navigation buttons to get the default value in the
Control -- Default Value only applies to new records). I've used the same
name for the Control as for the Field it Displays; I've used a different
name for the Control and Field. I even tried adding. Value to the expression
you used, and I never got the value displayed in the Control on the Form.