Combo -Text box link causes Access to Crash

[Frankie_The_Flyer]

I've got a bit of a 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. (This is so I can show multiple records for that employee without having their name repeated at each one). 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 their 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??)

 

[pr2-eugin]

Use the Expression builder.. Rather than typing it by hand. See if that fixes your problem.

 

[Frankie_The_Flyer]

Thanks PR2-eugin! I tried that without success. Once I mover the employes Name into the body of the form everything worked as advertised.
Just another little thing in the learning process!