Populate Unbound text box based on combo box

Matthew

If you don't need to store the information in a table where is it going to come from?

The description of the inventory item is pre-defined in the inventory table. I do not need to store the inventory description in the main table that I am using because the inventory item number, the number in my combo box, will be stored there.

I can see your point though. If it would be easier to store the information in the table, I do not have a problem with that at all. It would make reporting and creating other forms a lot easier if the information was in the main table but I just did not think it was necessary.

Matthew

Matthew

I didn't realise you actually had an inventory table.

And it would not make sense to store that data in your table.

For one it would violate normalization rules and it would increase the size of your database.

The way you have it currently set up is fine.

I guess that was my initial question. How do I go about setting this up?

Would I just place =[Inven1].Column(3) in the Control Source for my text box with Inven1 being my combo box and the 3rd column being the full item descritption?

Matthew

Hi Matthew.
If I am reading your question correctly, this is a standard feature of Access. Base your combo box on a query that has both the number and description, you can set the column count of the combo box to "2" to display both columns, you can then set the "bound" column to the one with the number and store that number in the control source you are currently using. If you re-create the combo box based on a query with the number and name the wizard will help you get what you want.
HTH, Andrew.

Hi Matthew, expanding on the last 2 responses:

Andrew's method means there is no need to use a separate textbox. Set the column widths in the combo to 1;0;1.5 (inches, I'm assuming) and the List Width to 2.5 -- this way you'll see the code and the description in the combo list.

Alternatively, you can use the AfterUpdate eevent of the combo to push the value to your text box, and leave it so the combo only displays the code. Assuming the textbox is txtDesc, this code should do it:

[txtDesc] = [Inven1].Column(2) 'columns start at 0, so this is 3rd col

Insert that into the After Update event of the combo and give it a whirl

Denis

I understand what you are telling me to do, but when I place the following code in the After Update event of my combo box, it gives me an error stating that the INVENDESC1 macro cannot be found. INVENDESC1 is the name of the text box that I am trying to populate. INVEN1 is the name of the combo box.

[InvenDesc1] = [Inven1].Column(1)

What am I doing wrong?

Matthew