Embedded parameter queries

D

Davidrowland88

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.
 
T

Tom Lake

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
 
D

Dennis

The criteria in your query should look like this

[Forms]![FormName]![FieldNameOnForm]
 
D

Davidrowland88

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...
 
D

Dennis

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...
 
Top