Getting a combo box to display a default value related to another table/module

[Paranap]

I have a combo box linked to the table tbloperativetraining with the selections limited to the names in the table tbloperative. What I want is the default value to be the name of the operative who is using the comupter. I have a module which gives me the username of the person using the computer as a varible getusername so what I'd like to say is the default value =

[firstname] & " " & [surname] where [tbloperative].[username] = getusername(

but this doesn't work.
Not sure if its just the syntax or what im asking can't be done but any help would be appreciated.

Neil

[ranman256]

You're missing the last close paren at the end.
IF your function is there, and public, and returns the correct answer.