Text box in Form to return data of the query

  • Thread starter Thread starter an
  • Start date Start date
A

an

Hello!
I have a Report and Form based in query.
I know to create a text box in Report to return the
condition (part of String) requered in query.
But I don't know to make a similar Text Box in my Form to
obtained equal result.
The same code of the Report don't work in Form. Why not?
Thanks in advance.
an
 
an said:
Hello!
I have a Report and Form based in query.
I know to create a text box in Report to return the
condition (part of String) requered in query.
But I don't know to make a similar Text Box in my Form to
obtained equal result.
The same code of the Report don't work in Form. Why not?
Thanks in advance.
an
Click to expand...

Can you post us your code....?
Bye.
Alessandro(IT).
 
In Text box in Report:

[Word or * for all]

(Equal of the Query question and work fine, but not in
Form)

Thanks
an
 
an said:
Sorry:

In Control Souce of Text box.
an
Click to expand...

Sorry but my English is not so good and is possible that i misunderstand
your question, so eventually please tell my about it with a complete
exemple.

I think you need a parameter QRY and the best way is put in a QBE the
Form's control reference.
Why from a form...? because it's the first important HMI point.
So in a Criteria Row under your field in your QRY write:

Forms!FormName!ControlName & "*".

In this way your QRY take the parameter from the Form's control and filter
the data
like "A*"..... all records wich have your filed's first letter = A

Probably you ask all another thing.....!

Alessandro.(IT)
 
No! My english is it very bad, but...
So:
In Query, in Criteria row, I put [Word] (to filter certain
words in field Memo)
In my Report I have a Tex box to look the exact word,
request for Query. It work fine.
Now, I would like to make similar Text box in Form but I
don't know. This is my dificult, Ok?
Thanks again.
an
 
an said:
No! My english is it very bad, but...
So:
In Query, in Criteria row, I put [Word] (to filter certain
words in field Memo)
In my Report I have a Tex box to look the exact word,
request for Query. It work fine.
Now, I would like to make similar Text box in Form but I
don't know. This is my dificult, Ok?
Thanks again.
an
Click to expand...


Sorry, but i never use this function....!
I think is better don't have INPUT Criteria directly from your
QRY, you can have much difficulties......!
If you have your Personal InputCriteria Form you can
return your Criteria in any form by calling
Forms!CriteriaForm!TextBoxCriteria
from anyform you need...................................

In this way you can built a user friendly Input Form.....!

Bye.
Alessandro(IT).
 
Ok.
Grateful for your help.
Many thanks.
an
-----Original Message-----

"an" <[email protected]> ha scritto nel messaggio
No! My english is it very bad, but...
So:
In Query, in Criteria row, I put [Word] (to filter certain
words in field Memo)
In my Report I have a Tex box to look the exact word,
request for Query. It work fine.
Now, I would like to make similar Text box in Form but I
don't know. This is my dificult, Ok?
Thanks again.
an
Click to expand...


Sorry, but i never use this function....!
I think is better don't have INPUT Criteria directly from your
QRY, you can have much difficulties......!
If you have your Personal InputCriteria Form you can
return your Criteria in any form by calling
Forms!CriteriaForm!TextBoxCriteria
from anyform you need...................................

In this way you can built a user friendly Input Form.....!

Bye.
Alessandro(IT).


.
Click to expand...
 
Back
Top