By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,212 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

List Box lookup

P: n/a
jr
Have created a form
I have created 2 list boxes

I have a query showing in column 1, a 3 digit number ie 200
In column 2 of the query there is a description for 200 which is "Other
Debtors"
Of course this isnt the only row - There are in fact 300 approx - all unique

List box 1 Will contain the value the user wants to type in to look up the
description

List box 2 will show the loookup asnwer

What do you think is best
May 21 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"jr" <jr************@virgin.net> wrote in
news:3U***************@newsfe2-gui.ntli.net:
Have created a form
I have created 2 list boxes

I have a query showing in column 1, a 3 digit number ie
200 In column 2 of the query there is a description for 200
which is "Other Debtors"
Of course this isnt the only row - There are in fact 300
approx - all unique

List box 1 Will contain the value the user wants to type in to
look up the description

List box 2 will show the loookup asnwer

What do you think is best

I think it would be best for you to learn to express yourself in
a much more succinct fashion.

(Your rambling above does not give us any indication of what you
want to know.)

--
Bob Quintal

PA is y I've altered my email address.
May 21 '06 #2

P: n/a
jr
So are you saying I should not ramble -
Query!
Query1
Select El1code,el1Desc,el1level
from OAS.EL1_Element
Where El1code not null and El1level = 1
1,2;

Form 1 contains 2 list boxes
List box1 = User input - ie user will input El1Code
Listbox2 = User feedback ie user will see description

Query1 results are 300 rows approx

My question is how do I get ListBox2 to reference the value in listbox1 and
lookup the eqiv description in the Query1.

Have tried Expression builder and can refrence Listbox1 but cant seem to
find an appropriate lookup function for listbox2 and the query1.
"Bob Quintal" <rq******@sympatico.ca> wrote in message
news:Xn**********************@207.35.177.135...
"jr" <jr************@virgin.net> wrote in
news:3U***************@newsfe2-gui.ntli.net:
Have created a form
I have created 2 list boxes

I have a query showing in column 1, a 3 digit number ie
200 In column 2 of the query there is a description for 200
which is "Other Debtors"
Of course this isnt the only row - There are in fact 300
approx - all unique

List box 1 Will contain the value the user wants to type in to
look up the description

List box 2 will show the loookup asnwer

What do you think is best

I think it would be best for you to learn to express yourself in
a much more succinct fashion.

(Your rambling above does not give us any indication of what you
want to know.)

--
Bob Quintal

PA is y I've altered my email address.

May 21 '06 #3

P: n/a
"jr" <jr************@virgin.net> wrote in
news:GQ****************@newsfe2-win.ntli.net:
So are you saying I should not ramble -
Query!
Query1
Select El1code,el1Desc,el1level
from OAS.EL1_Element
Where El1code not null and El1level = 1
1,2;

Form 1 contains 2 list boxes
List box1 = User input - ie user will input El1Code
Listbox2 = User feedback ie user will see description

Query1 results are 300 rows approx

My question is how do I get ListBox2 to reference the value in
listbox1 and lookup the eqiv description in the Query1.

Have tried Expression builder and can refrence Listbox1 but
cant seem to find an appropriate lookup function for listbox2
and the query1.

why are you saying you are using two listboxes?
Textboxes would be better, or a single listbox with two columns,

Either way, you need to put the value for the value typed into
the listbox1 by setting the controlsource for textbox2 to
=dLookup("el1Desc","Query1","El1code = " & Forms!nameofForm!
textbox1")
--
Bob Quintal

PA is y I've altered my email address.
May 21 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.