dlookup

[kevcar40]

hi
i am trying to return the supervisor number forma table dpending o what calues are selected from two combo boxes on a form

i have wrote the code below which is run from and afterupdate event
the first half of the code runs fine when i add the AND the code crashes


Me.Text124.Value = DLookup("fldsupernumber", "TblAreas", "fldarea = [Cbo_team]" And "fldshift = [Cbo_shift]")

can anyone please help me resolve this problem

thanks

kevin

 

[Bob Quintal]

hi
i am trying to return the supervisor number forma table dpending o
what calues are selected from two combo boxes on a form

i have wrote the code below which is run from and afterupdate
event the first half of the code runs fine when i add the AND the
code crashes


Me.Text124.Value = DLookup("fldsupernumber", "TblAreas", "fldarea
= [Cbo_team]" And "fldshift = [Cbo_shift]")

can anyone please help me resolve this problem

thanks

kevin

You have some extra quotes in the criteria in the dLookup.
Try "fldarea = [Cbo_team] And fldshift = [Cbo_shift]"

 

[kevcar40]

hi i am trying to return the supervisor number forma table dpending o what calues are selected from two combo boxes on a form i have wrote the code below which is run from and afterupdate event the first half of the code runs fine when i add the AND the code crashes Me.Text124.Value = DLookup("fldsupernumber", "TblAreas", "fldarea = [Cbo_team]" And "fldshift = [Cbo_shift]") can anyone please help me resolve this problem thanks kevin

thanks works a treat

kevin