DLOOKUP in textbox on form

[laavista]

I'm using Access 2010. I'm having trouble with dlookup. I've spent over 5 hours searching forums, etc., and can't figure out what I'm doing wrong.



Table name: tblTier2
Fields: Tier2ID, autonumber
Tier2FieldType, text

I have an unbound list box on a main menu form.
The listbox control is numeric and called: lstItem

I tried putting the following in the textbox:

Neither of these worked:
= DLookUp("[Tier2FieldType]","[tblTier2]","[Tier2ID]=" & [lstitem])
=DLookUp("[Tier2FieldType]","[tblTier2]","[Tier2ID]=" & [lstitem].[column](0))

I wanted to see if the lstItem was the problem, so I put ths following in the text box. :
=[lstitem] (it returned the ID number selected from the list box, e.g., 809)

Your help would be so appreciated.
Thanks.

[June7]

Is the textbox also on the main form?

Why do you need to show this value in textbox? Why not just have it as a column in the listbox?

Why is this an unbound listbox?

[laavista]

I need to cascade information. I have two list boxes--both on the 'main form'. The user selects data from tier1 in listbox1. Listbox2 displays the data for the tier1 selection. I now need to display 9 fields for the tier2 selection and some of the fields are lengthy.

Listbox 1 for tier1 is associated with a table.
Listbox 2 for tier2 is unbound
This works.

Now I need to display the 9 fields based on the user's selection from listbox 2. I thought a dlookup for each of the 9 fields might work best. I've tried adding in a form, but could not get that to work either.

Any suggestions?
Thanks for looking at this.

[burrina]

Where are you wanting to display these 9 fields at? You don't need a dlookup, just make the field equal the value for each row.

[June7]

Include the fields as columns in combobox. Then expression in textbox references the listbox column index.

=[lstitem].[Column](3)

What purpose does the second unbound combobox serve?

[laavista]

I want to display the 9 fields anywhere on the form, but the form is not based on the table where the 9 fields reside.

[laavista]

Please ignore this question. I found I had an error in my database structure.
Thank you for your help.