dlookup

  • Thread starter Thread starter kevcar40
  • Start date Start date
K

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
 
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
Click to expand...

You have some extra quotes in the criteria in the dLookup.
Try "fldarea = [Cbo_team] And fldshift = [Cbo_shift]"
 
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
Click to expand...

thanks works a treat

kevin
 
Back
Top