form field data as criteria

  • Thread starter Thread starter RipperT
  • Start date Start date
R

RipperT

What is the syntax to type in the 'criteria' field of a
query when you want to plug in the data from a form field
when the query runs?

Thanx millions?

Rip
 
When I use this, it still prompts for the parameter. I
would like it to run automatically using the data from a
field in the current record. Is this possible?

Rip

-----Original Message-----
Rip,

It would be:

[Forms]![YourFormName]![YourControlName]

HTH,
Nikos

What is the syntax to type in the 'criteria' field of a
query when you want to plug in the data from a form field
when the query runs?

Thanx millions?

Rip
Click to expand...


.
Click to expand...
 
The form must be open. A query will not open a form.

--
Duane Hookom
MS Access MVP


RipperT said:
When I use this, it still prompts for the parameter. I
would like it to run automatically using the data from a
field in the current record. Is this possible?

Rip

-----Original Message-----
Rip,

It would be:

[Forms]![YourFormName]![YourControlName]

HTH,
Nikos

What is the syntax to type in the 'criteria' field of a
query when you want to plug in the data from a form field
when the query runs?

Thanx millions?

Rip
Click to expand...


.
Click to expand...
Click to expand...
 
The form is open. The query is triggered by a command
button in the form, taking (hopefully) the field contents
from a field in the form and using it for the query
criteria. Can I get it to do this without a dialog box
prompt asking for the parameter?

Rip
-----Original Message-----
The form must be open. A query will not open a form.

--
Duane Hookom
MS Access MVP


When I use this, it still prompts for the parameter. I
would like it to run automatically using the data from a
field in the current record. Is this possible?

Rip

-----Original Message-----
Rip,

It would be:

[Forms]![YourFormName]![YourControlName]

HTH,
Nikos

"RipperT" <[email protected]> wrote
Click to expand...
in
message
What is the syntax to type in the 'criteria' field of a
query when you want to plug in the data from a form field
when the query runs?

Thanx millions?

Rip


.
Click to expand...
Click to expand...


.
Click to expand...
 
You have probably spelled something wrong. What is your query's SQL as well
as your form and control name?

--
Duane Hookom
MS Access MVP


RipperT said:
The form is open. The query is triggered by a command
button in the form, taking (hopefully) the field contents
from a field in the form and using it for the query
criteria. Can I get it to do this without a dialog box
prompt asking for the parameter?

Rip
-----Original Message-----
The form must be open. A query will not open a form.

--
Duane Hookom
MS Access MVP


When I use this, it still prompts for the parameter. I
would like it to run automatically using the data from a
field in the current record. Is this possible?

Rip


-----Original Message-----
Rip,

It would be:

[Forms]![YourFormName]![YourControlName]

HTH,
Nikos

message
What is the syntax to type in the 'criteria' field of a
query when you want to plug in the data from a form
field
when the query runs?

Thanx millions?

Rip


.
Click to expand...


.
Click to expand...
Click to expand...
 
That did it. I had the wrong form name plugged in.
Thanx a bazillion!

Ripper
-----Original Message-----
You have probably spelled something wrong. What is your query's SQL as well
as your form and control name?

--
Duane Hookom
MS Access MVP


The form is open. The query is triggered by a command
button in the form, taking (hopefully) the field contents
from a field in the form and using it for the query
criteria. Can I get it to do this without a dialog box
prompt asking for the parameter?

Rip
-----Original Message-----
The form must be open. A query will not open a form.

--
Duane Hookom
MS Access MVP


"RipperT" <[email protected]> wrote
Click to expand...
in
message
When I use this, it still prompts for the parameter. I
would like it to run automatically using the data
Click to expand...
from
a
field in the current record. Is this possible?

Rip


-----Original Message-----
Rip,

It would be:

[Forms]![YourFormName]![YourControlName]

HTH,
Nikos

"RipperT" <[email protected]>
Click to expand...
wrote
in
message
What is the syntax to type in the 'criteria'
Click to expand...
field
of a
query when you want to plug in the data from a form
field
when the query runs?

Thanx millions?

Rip


.



.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top