Help Please

[Aaron M]

Ok i have a table (info) with information pre filled on it.
I then have another table (items) with two combo boxes on it.



The first combo box is a list of codes (column 1 of table info)
The second combo box is a list of discriptions (column 2 of table info)

All i want is the second combo box to auto fill the description.
The code and discription that match eachother are in the same row on my info sheet.

Im sure this is realy easy using the criteria box but i have been pulling my hair out for hours and i just cant work it out.

Thank you in advance for any help Aaron

[alansidman]

Why are you using combo boxes in a table? Data entry and this type of activity should be handled through a form. With data entry in a form, you have more flexibility and can use VBA to assist if necessary.

Alan

[Aaron M]

there is a form in there that i am using to select the data but when i used the event procedure in vba it would only work with one reccord at a time. i followed the tutorial built into access.

[alansidman]

Aaron;
Take a look at this web site. Scroll down until you come to combo boxes. There are three tutorials. I am sure you will benefit from looking at these and applying the principles shown

http://www.datapigtechnologies.com/AccessMain.htm

Alan

[Aaron M]

Thanks will do