hi, it works, but idid in other.
now i have a textbox that will receive the code, but to receive i have to
click in the listbox of the code, how can i do to the textbox receive the
value automaticly without press the lisbox. thanks
"Ofer" escreveu:
> Let start from the beginning
> 1. Create a list box that include all the fields in the table
> Select [Name], code, adress From TableName
> You don't need to display all the fields in the list box, you can display
> only the name
>
> 2. On the after update event of the lsit box, write
>
> Me.TextBoxName = Me.ListBoxname.Column(2)
>
> --
> 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" wrote:
>
> > hi, it didn't work, i will explain better
> > i have a table with this fields----> Name, code, adress
> > now i have a listbox with all the names in the table and when i select one
> > of them i want in the code, adress listbox appear the values corresponding to
> > the name. i use the listbox, because, i am using an SQL statement to check
> > the values of the code and the adress. if try with the texbox it don't appear
> > nothing, so if you know how to get the value from the name selected to a
> > testbox.
> > thanks
> >
> > "Ofer" escreveu:
> >
> > > If you have a list of names, and you select just one of them, to move the
> > > value selected in the list box to the text box use the After update event of
> > > the ListBox and write the code
> > >
> > > Me.TextBoxName = Me.ListBoxName
> > >
> > > Now, if the list box contain more then one field, and you want to transfer
> > > the second field, then use this
> > > Me.TextBoxName = Me.ListBoxName.column(1)
> > >
> > > The column number count start with 0
> > > --
> > > 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" wrote:
> > >
> > > > hi again,
> > > > i have a list box, that have a list with the names, and when i select one
> > > > name it appear the code (Listbox), i use a listbox because i can't retrieve
> > > > the value with the select statement, from the listbox names. if you know
> > > > other way to get the value without using listbox, i will aprecciate.
> > > > thanks
> > > >
> > > > "Ofer" escreveu:
> > > >
> > > > > There is no reason to create a list box for only one value, you can retrieve
> > > > > the value using dlookup, or any other method
> > > > > If you tell us what you are trying to do, mybe we can help you and recommand
> > > > > a different method
> > > > >
> > > > > To copy from a list box, you need to select the record and then
> > > > > Me.TextBoxName = Me.ListBoxName
> > > > > --
> > > > > 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" wrote:
> > > > >
> > > > > > hi,
> > > > > > i'm trying to copy the values from one listbox to the textbox, how can i do
> > > > > > this?
> > > > > > the listbox just show one value. i have to use listbox because it is the
> > > > > > value from an SQL statement.
> > > > > > Any sugestion
> > > > > >
Similar Threads
