Embedded parameter queries

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

 

[Tom Lake]

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

 

[Guest]

The criteria in your query should look like this

[Forms]![FormName]![FieldNameOnForm]

 

[Guest]

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.

The criteria in your query should look like this

[Forms]![FormName]![FieldNameOnForm]

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

 

[Guest]

You have either got [Forms!searchcustID!search] as the criteria or
[Forms]![searchcustID]![search] but the form isn't open

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.

The criteria in your query should look like this

[Forms]![FormName]![FieldNameOnForm]

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