Combobox then autofill

[vand_uk]

OK i was going strong before I hit a brick wall. I have created a form with cascading combo boxes on, first one chooses the generic item, the second then chooses a specific one, then i want to fill in all other details on the form automatically from the secound combobox (the specific item) For example to show that particular serial number. Is there anyway I can do this?

Thanks

 

[fuzzygeek]

http://www.mvps.org/access/forms/frm0058.htm