Get information from selected item of ListBox (1 Viewer)

Surka · Nov 23, 2013

Dear Santa,

from a search form example I got from this forum I made the following:

A listBox which shows results as you type, using a query.

This listBox has 1 column, I need it that way.

What I need is to show the information from the selected item of the listBox on a textBox, getting this info from the results of the query.

I found 2 answers which I don't like:

1- =DLookUp("[Column]","[Query]") as source of textBox
This shows only information from the first row. So if you select the second result from the listBox, it still shows the first row.

2- =SearchResults.column(int) as source of textbox
It does not work, because listBox has only 1 column.

Meanwhile I will continue searching, and the question:
Could you please help me with another solution?

Thanks.

pbaldy · Nov 23, 2013

Why not include the other columns in the listbox but hide them, and use method 2?

Surka · Nov 23, 2013

I tried that option but it did not work. I will try again because you name it.

Surka · Nov 23, 2013

I realized I was adding fields onto the Query, and not on the query based listBox. Now it works, but it is difficult to add as many textbox as field are, and adding the code: =[SearchResults].[column](0) to each textbox. I do not know what column number is for each field.

Is there a tidier way of doing this? Adding as many textbox as columns on the listBox are.

pbaldy · Nov 24, 2013

The column numbers are in the order of the fields in the SELECT statement, starting with 0.

Get information from selected item of ListBox (1 Viewer)

Surka

IT dude

pbaldy

Wino Moderator

Surka

IT dude

Surka

IT dude

pbaldy

Wino Moderator

Similar threads

Users who are viewing this thread