Populating field based on combobox selection

[Kozbot]

Hello

I have a table of raw materials that have two fields, their stock code and longer description.

I have another table that is tracking the usage of these materials. I want both the stock code and longer description to be recorded in the usage table.

I want the "Description" field in the usage table form to auto populate when the user selects the corresponding stockcode from a combobox.

How is this easily done?

Thank you

 

[pr2-eugin]

Hello Kozbot, the truth of the matter is you do not need to store this information, when needed you can use JOINS to show the desired info.. You can also show the description in an UNBOUND control on the Form, Paul explains this in his site, Autofill from ComboBox.

 

[Kozbot]

Hello Kozbot, the truth of the matter is you do not need to store this information, when needed you can use JOINS to show the desired info.. You can also show the description in an UNBOUND control on the Form, Paul explains this in his site, Autofill from ComboBox.

exactly what i was looking for thank you

 

[Frankie_The_Flyer]

I've got a bit of a further problem with linking a text box to a ComboBox. I have an employee name in a field [EmployeeName] that sits in the Header of a Form. I also have the name of contact [ContactName] that sits in the Detail area of the form.
Both names come from their own tables that have all the contact numbers and e-mail addresses in columns
I have linked the name to text boxes [ContactPhone] & [EmployeePhone] with their relevant phone numbers in within the Detail area of the form.
The ContactPhone that has the ContactName within the Details part of the form works well with no problems by putting =[ContactName].Column(1) in the Control Source

However when I put =[EmployeeName].Column(1) in the relevant Control Source (and / or EmployeeEMail in a second text box), once I have saved the form in Design view and returned to Form view, Access crashes and shuts down!
If I remove the wording from the control source Access doesn't crash.

Anyone else seen this and know what the cause may be and how to fix it?? (Suspect it's because the EmployeeName field is in the header??)
:banghead: