LookUp for a combo box?

[Adam7]

Hi all,

I haven't used access properly for years so the problem I have probably has a very simple solution that I have completely forgotten about.

I am adding a field to my database called "category" and another next to it called "code" which is a unique code to each category.

The "category" field is a combo box that lists about 500 categories. How can I make it so that when I select a category from the combo box, the "code" field automatically changes to the relevant code? I'm sure it requires some sort of lookup from a table but just can't remember.

It's probably really simple but any help would much appreciated!



Thanks,

Adam.

[alansidman]

I think that this is what you are looking for.

http://www.baldyweb.com/Autofill.htm

Make sure that you do your lookups in a form and not directly in a table.

http://access.mvps.org/access/lookupfields.htm

[Adam7]

Thanks for your reply Alan.

So far, I have a working autofill on my form.
My only problem now is that when the field is "autofilled", it does not update on the table. Usually this wouldn't be a problem but a few people at work prefer to view everything in table view so it is vital that when one of the categories/codes is selected on the form, it updates the table.

Would you be able to explain how I would go about doing that?

Thanks alot,

Adam.

[alansidman]

Your users should not be allowed to look at your tables. If you wish to simulate a table view in a form, then use a datasheet view for your form. The data will appear as it is in a form, but looks like a table.

[Adam7]

Ok then, will have to make do with datasheet view.

Thanks for all your help!

Adam.