please help me i am in a problem

[baroom]

hello
i am very new to access but i have created an inventory from in access this form has fields like item number, item name unit code unit name ect...
my problem is when ever the user enters an item number then it should be check item table (not the table working behind this form). for avalability. if the item number is present there then it should display the name automatically in this field of item name of this form. and if unit code is entered then it should display the unit name from the unit table where it is already present.
how to do this i am not getting please help me asw i told i am very new to access.
so please give me the detail answer for this.
thanks in advance

 

[Mr. B]

baroom,

Instead of having your user enter the Item number manually, you should change the text box where they are now entering the Item number into a combo box. Have your combo box display all of the Items from the Unit Table. Make sure that you set the "Limit To List" property for this combo box to "Yes". This way they cannot select or enter a value that is not already in the list.

HTH