Populate data based on selction from combo box

[woundup]

I'm no good when it comes to code so looking for some help. I have a form that has a combo box in the header. I want to be able to select an employee name and the remaining info in the detail section of the form populate. My other fields are:

Employee Name - text box
Reporting Unit - combo box
Department - combox box
Primary Phone - text box
Secondary Phone - text box
Emergency Contact Name - text box
Relationship - text box
Emergency Contact Primary Phone - text box
Emergency Contact Secondary Phone - text box
B-Alert Txt - combo box
B-Alrt Phone - combo box
e-mail - text box

Any help will be greatly appreciated.

[rzw0wr]

First of all, you are showing Employee Name as a text box.
We would also need to see how these fields are related.
Is this all 1 table?

If your tables structure is correct (normalized) then code (VBA) may not be required.

A little more information or better yet an upload of your database would help.

EDIT: BTW, welcome to AccessForums.
Dale

[woundup]

All the info is in 1 table (tbl_Master Employee Contact Info) and I am using frm_Change Employee Contact Info. I will attach DB as soon as I can figure out how.

[woundup]

Populate data based on selction from combo box

I'm no good when it comes to code so looking for some help. I have a form that has a combo box in the header. I want to be able to select an employee name and the remaining info in the detail section of the form populate. My other fields are:

Employee Name - text box
Reporting Unit - combo box
Department - combox box
Primary Phone - text box
Secondary Phone - text box
Emergency Contact Name - text box
Relationship - text box
Emergency Contact Primary Phone - text box
Emergency Contact Secondary Phone - text box
B-Alert Txt - combo box
B-Alrt Phone - combo box
e-mail - text box

All info is pulled from1 table

Any help will be greatly appreciated.

[Bob Fitz]

Can you post a copy in A2003 mdb format

[pbaldy]

I merged your duplicate threads since they both had responses.

[rzw0wr]

Database 2010 to 2003 format.
One form and report may not be complete of present.



Employee Contact DB - Copy.zip

EDIT: Sorry this db is for Bob.
Dale