Run-Time Error3705

[Malta393]

I have inpt the following code in order to get a conbo box selection to complet two other textboxes on my form
Privat Sub First_NameTxtbox_Afterupdate
SurnameTxtbox=DLookup("[LastName]","ManagerTable","First_Name = "&First_NameTxtbox)
DoCmd.Close acTable,"Manager"
CostCentreNoTxtbox=DLookup("CostCentreNo","ManagerTable","First_Name = & First_NameTxtbox)

I can't seem to get it to work-Can anyone help I'm A COMPLETE NOVICE AT THIS.[DAZED]

 

[Aivars]

Private Sub First_NameTxtbox_Afterupdate()
SurnameTxtbox=DLookup("LastName","ManagerTable","First_Name = '" & me.First_NameTxtbox & "'&quot

'DoCmd.Close acTable,"Manager" Wrong command string because your table isn't opened, I think

CostCentreNoTxtbox=DLookup("CostCentreNo","ManagerTable","First_Name = '" & me.First_NameTxtbox & "'&quot

Aivars