display the data in the form field

[baroom]

please help me in displaying the data from table. like i have 2 feilds item no and item name.
when ever i enter item no in the form then the item name realted to that item no should e displayed.
please help me

 

[missinglinq]

Answered in thread http://www.access-programmers.co.uk/forums/showthread.php?t=173425

Please do not post a question multiple times.

 

[baroom]

i did exactly as u said

Private Sub Item_No_AfterUpdate()
Me.Item_Name = DLookup("[Item Name]", "YourTableName", "[Item No] = '" & Me.Item_No & "'")
End Sub
but at the time of running the form i am getting the runtime error
please help me

 

[marianne]

did you change the YourTableName to the name of your actual table name?

 

[baroom]

yes i chenge the table name to item_table even then it is giving me the run time error.
or is it due to that the table working behind the form is inventory_table and i want to display the data from the item_table.
please help me