Embedded parameter queries

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

Guest

I have mad a parameter query to find a customers details by using their ID.

The query works fine and the seperate window asking for the ID appears and
the results follow after you have entered a number.

I was wondering if you can use a text box in a form to act as the parameter
query criteria..... very hard to explain what i mean so if you are unsure
please post and tell me.
 
Davidrowland88 said:
I have mad a parameter query to find a customers details by using their ID.

The query works fine and the seperate window asking for the ID appears and
the results follow after you have entered a number.

I was wondering if you can use a text box in a form to act as the
parameter
query criteria..... very hard to explain what i mean so if you are unsure
please post and tell me.
Click to expand...

You can make the criteria be the name of a field on a form.
This will give you the effect you're looking for.

Tom Lake
 
Thanks for help. have trierd that but all that happens is the input window
appears again but just with all the info in the [] e.g
Forms!searchcustID!search all appears with the input box.

Dennis said:
The criteria in your query should look like this

[Forms]![FormName]![FieldNameOnForm]

Tom Lake said:
You can make the criteria be the name of a field on a form.
This will give you the effect you're looking for.

Tom Lake
Click to expand...
Click to expand...
 
You have either got [Forms!searchcustID!search] as the criteria or
[Forms]![searchcustID]![search] but the form isn't open

Davidrowland88 said:
Thanks for help. have trierd that but all that happens is the input window
appears again but just with all the info in the [] e.g
Forms!searchcustID!search all appears with the input box.

Dennis said:
The criteria in your query should look like this

[Forms]![FormName]![FieldNameOnForm]

Tom Lake said:
I have mad a parameter query to find a customers details by using their ID.

The query works fine and the seperate window asking for the ID appears and
the results follow after you have entered a number.

I was wondering if you can use a text box in a form to act as the
parameter
query criteria..... very hard to explain what i mean so if you are unsure
please post and tell me.

You can make the criteria be the name of a field on a form.
This will give you the effect you're looking for.

Tom Lake
Click to expand...
Click to expand...
Click to expand...
 
Back
Top