filter to another textbox

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

Guest

Hi, i'm with big problems to do this:
whta i want to do, is, i have two textbox one call Tpesquisa and the other
one calls Lmedicamento (this one is a listbox). in the Tpesquisa when i put,
for example the word a or b, etc, i want in the Lmedicamento shows the words
that have in the table beginning with the letter put in the Tpesquisa.
Any Sugestion, thanks
 
In the Row Source of the List box have reference to the field in the form, as
a criteria

Select Fieldname From TableName Where FieldName Like
Forms![FormName]![Tpesquisa] & "*"
==============================================
On the after update event of the Tpesquisa field write the code
Me.Lmedicamento.Requery
 
thank you very much,
the code you gave me it was corretly, it works well, but i have another
question?
when i put some letter in the textbox (Tpesquisa) and i hit ENTER he select
the words beginning with the letter in the listbox. my question know is, i
have another two or three textbox, that correspod to the values of the word i
wnat to select. when i select the word in the listbox he don't change the
values of the other textboxes, WHY? i already hit ENTER and two click Mouse.
Any sugestion?
thanks


"Ofer" escreveu:
In the Row Source of the List box have reference to the field in the form, as
a criteria

Select Fieldname From TableName Where FieldName Like
Forms![FormName]![Tpesquisa] & "*"
==============================================
On the after update event of the Tpesquisa field write the code
Me.Lmedicamento.Requery
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck



Bruno Coelho said:
Hi, i'm with big problems to do this:
whta i want to do, is, i have two textbox one call Tpesquisa and the other
one calls Lmedicamento (this one is a listbox). in the Tpesquisa when i put,
for example the word a or b, etc, i want in the Lmedicamento shows the words
that have in the table beginning with the letter put in the Tpesquisa.
Any Sugestion, thanks
Click to expand...
Click to expand...
 
How did you link the other text boxes to the list box?
You can either write in the control source of each text box the relavent
column in the list box, such as
=[Lmedicamento].column(1) ' stand for the second column, the column count
start with 0

Or
On the after update event of the Lmedicamento list box you can write the code
Me.TextBox1 = Me.Lmedicamento.column(1)
Me.TextBox2 = Me.Lmedicamento.column(2)
===========================================
I hope I understand your question.
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck



Bruno Coelho said:
thank you very much,
the code you gave me it was corretly, it works well, but i have another
question?
when i put some letter in the textbox (Tpesquisa) and i hit ENTER he select
the words beginning with the letter in the listbox. my question know is, i
have another two or three textbox, that correspod to the values of the word i
wnat to select. when i select the word in the listbox he don't change the
values of the other textboxes, WHY? i already hit ENTER and two click Mouse.
Any sugestion?
thanks


"Ofer" escreveu:
In the Row Source of the List box have reference to the field in the form, as
a criteria

Select Fieldname From TableName Where FieldName Like
Forms![FormName]![Tpesquisa] & "*"
==============================================
On the after update event of the Tpesquisa field write the code
Me.Lmedicamento.Requery
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck



Bruno Coelho said:
Hi, i'm with big problems to do this:
whta i want to do, is, i have two textbox one call Tpesquisa and the other
one calls Lmedicamento (this one is a listbox). in the Tpesquisa when i put,
for example the word a or b, etc, i want in the Lmedicamento shows the words
that have in the table beginning with the letter put in the Tpesquisa.
Any Sugestion, thanks
Click to expand...
Click to expand...
Click to expand...
 
it's not like that, my other textbox are different vallues, for example, i
have the listbox, the Tpesquisa(Textbox), and i have another textboxes with
different values, like, one textbox (Tcode) he have to check what it the name
in the list to get the right value code and o have another three in the same
way. i hope ou understand this.
thanks

"Ofer" escreveu:
How did you link the other text boxes to the list box?
You can either write in the control source of each text box the relavent
column in the list box, such as
=[Lmedicamento].column(1) ' stand for the second column, the column count
start with 0

Or
On the after update event of the Lmedicamento list box you can write the code
Me.TextBox1 = Me.Lmedicamento.column(1)
Me.TextBox2 = Me.Lmedicamento.column(2)
===========================================
I hope I understand your question.
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck



Bruno Coelho said:
thank you very much,
the code you gave me it was corretly, it works well, but i have another
question?
when i put some letter in the textbox (Tpesquisa) and i hit ENTER he select
the words beginning with the letter in the listbox. my question know is, i
have another two or three textbox, that correspod to the values of the word i
wnat to select. when i select the word in the listbox he don't change the
values of the other textboxes, WHY? i already hit ENTER and two click Mouse.
Any sugestion?
thanks


"Ofer" escreveu:
In the Row Source of the List box have reference to the field in the form, as
a criteria

Select Fieldname From TableName Where FieldName Like
Forms![FormName]![Tpesquisa] & "*"
==============================================
On the after update event of the Tpesquisa field write the code
Me.Lmedicamento.Requery
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck



:

Hi, i'm with big problems to do this:
whta i want to do, is, i have two textbox one call Tpesquisa and the other
one calls Lmedicamento (this one is a listbox). in the Tpesquisa when i put,
for example the word a or b, etc, i want in the Lmedicamento shows the words
that have in the table beginning with the letter put in the Tpesquisa.
Any Sugestion, thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top