Using form to enter information into a table

[Chris2810]

Hello all.



I have a database for keeping track of supplies inventory. A form is used to enter new inventory transactions such as if a case of soap was transferred from storage to a store.

The user isn't going to know the item number off the top of their head. So what they will do is select the description from the description combo box. I want the item number associated with that description to automatically populate so that it is stored in the transaction table with the rest of the information regarding that transaction.

I wasn't really sure what the best way to do this would be so I used the Dlookup function in a text box on the form that looks up the item number from the items table where the description selected on the form = the description in the items table. So now when the user selects the description, the text box automatically populates with the appropriate item # which is what I wanted. The problem is that when the data is entered into the transactions table, the item # is omitted.

So how do I create a form that will enter data into the Transactions table and get the item # field to automatically populate when the corresponding description field is entered?

[vicsaccess]

sounds like a combo box would do what you want. there is a lot of information out there on this subject just do a search. here's one i found real quick.
https://www.youtube.com/watch?v=rSPS24EfijI

[Chris2810]

That was exactly what I needed!!!! THANK YOU!!!!