reference to a form's field, in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Anyone have an idea why the following is not working for me? I have an open form, which launches a process that runs queries. In one of the queries, I want to populate a field with the value from a text box on the form. (I have an end date field on form that user selects, want to list that same selected date in an 'as of date' column in query.) The query allows the syntax I'm using, but always returns an empty value. (And yes, the form is still open when query runs.

Open form and field on it: [Forms]![iFrmRptSel]![txtEnd

SQL of query: "SELECT "dB" AS Source, [Forms]![iFrmRptSel]![txtEnd] AS [As of], tblName.QUANTITY_ORDERED*tblName.LIST_PRICE_PER_UNIT*1.12 AS [Total Amount
FROM tblName;

Why does this not return the date value that is present in the form's field? Just returns empty cells, for the 'As of' column
 
You should delimit the parameter so the query knows what
data type to assign to it.

"SELECT 'dB' AS Source, '#' & [Forms]![iFrmRptSel]!
[txtEnd] & '#' AS [As of], "...

Is 'txtEnd' a bound control (does it have a control
source)? if so, you'll need to either save the record
prior to running the query, or reference the
control's 'Text' property

[Forms]![iFrmRptSel]![txtEnd].[Text]

good luck!
-----Original Message-----
Anyone have an idea why the following is not working for
Click to expand...
me? I have an open form, which launches a process that
runs queries. In one of the queries, I want to populate a
field with the value from a text box on the form. (I have
an end date field on form that user selects, want to list
that same selected date in an 'as of date' column in
query.) The query allows the syntax I'm using, but always
returns an empty value. (And yes, the form is still open
when query runs.)
Open form and field on it: [Forms]![iFrmRptSel]![txtEnd]

SQL of query: "SELECT "dB" AS Source, [Forms]!
Click to expand...
[iFrmRptSel]![txtEnd] AS [As of],
tblName.QUANTITY_ORDERED*tblName.LIST_PRICE_PER_UNIT*1.12
AS [Total Amount]
FROM tblName;"

Why does this not return the date value that is present
Click to expand...
in the form's field? Just returns empty cells, for
the 'As of' column.
 
THANKS! You da ma

----- Elwin wrote: ----

You should delimit the parameter so the query knows what
data type to assign to it

"SELECT 'dB' AS Source, '#' & [Forms]![iFrmRptSel]
[txtEnd] & '#' AS [As of], "..

Is 'txtEnd' a bound control (does it have a control
source)? if so, you'll need to either save the record
prior to running the query, or reference the
control's 'Text' propert

[Forms]![iFrmRptSel]![txtEnd].[Text

good luck
-----Original Message----
Anyone have an idea why the following is not working for
Click to expand...
me? I have an open form, which launches a process that
runs queries. In one of the queries, I want to populate a
field with the value from a text box on the form. (I have
an end date field on form that user selects, want to list
that same selected date in an 'as of date' column in
query.) The query allows the syntax I'm using, but always
returns an empty value. (And yes, the form is still open
when query runs.
Open form and field on it: [Forms]![iFrmRptSel]![txtEnd
SQL of query: "SELECT "dB" AS Source, [Forms]
Click to expand...
Click to expand...
[iFrmRptSel]![txtEnd] AS [As of],
tblName.QUANTITY_ORDERED*tblName.LIST_PRICE_PER_UNIT*1.12
AS [Total Amount
FROM tblName;
Click to expand...
in the form's field? Just returns empty cells, for
the 'As of' column
 
Back
Top