Access 2010 Selecting data from a table and auto-filling fields

[LaughingBull]

I have staff table which is a lookup field on the phone call table.
when the phonecall form opens I want the employee field to auto fill in the employees name from the lookup field according to there security level.
so something like this
On Open
Select Case Forms!frmLogin!cboUser.Column(4)
Case X = 4'the employees security level'
Case X = Insert Table_tblPhoneCalls!EmployeeID"4" into Form_frmPhoneCalls!Employee.
End Select


of course this is a syntax error as I do not know the correct code words.

can any one help

[June7]

Doesn't make sense. Exactly what is the business process involved here? User opens form. User selects name in combobox. Then you want what to happen?

Is this form bound to table? Is the combobox bound to field?