Linking fields.

[Foster]

I am relatively new to Access so please excuse me as I am sure my question is quite simple.
I am trying to join information together within a form. For example, I have a table with 2 fields (Materials and Price) I have created a form (form 2) with a drop down box to choose a material from the material table. When the material is picked, i need the price to automatically appear and the stored within the price field within Form 2. At the moment, I cannot link the material to the price, which means I have to choose the material and then add the price seperately.
Hope this makes sense.

 

[jeremie_ingram]

Try adding the combo box useing the wizard. You should be prompted with 3 options, select the third which states something like "Find a record based on the value selected in the combo box".
If both items are in one table, and you have the datasource set properly, then the field for price should fill in automatically.

 

[coryt]

Foster try this

 

[Foster]

Cheers Fella's. Work a treat. Much appreciated. Foster.