Forms Question regarding combo boxes.

[HeyYouYesYouNoNotYouYou]

Hi,

I am currently looking at improving a form that i have created which has the purpose of entering stock orders into a table so that they can be stored and then used to actually send off to suppliers. The fields that are filled in manually are, Product ID, Product description, Price, quantity, carrier name and carrier ID. What i am looking to do is to change the Product ID field and the Carrier ID field to combo boxes so they can be quickly chosen. However, i would like the other fields such as price, description and carrier name to be filled in automatically depending on what ID is entered. Is there a way possible to do this?

Thanks in advance,

Heyyouyesyounonotyouyou

 

[xenou]

If the related fields are in a subform they should fill automatically based on the parent-child relationship. Otherwise, you can also use DLookup() formulas to find the related information (or script them to populate with VBA if you prefer).
ξ

 

[HeyYouYesYouNoNotYouYou]

Ok, cheers for the help, mate.