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.