DLookup woes-not updating

[netrusher]

Below is the code I have on a subform (MainEntryQrySelectSubFRM1).
Can someone tell me what is wrong with this code? When I
click the next button I want the Value in the Method10
field to change according to what the Pull Code Value is
in the query for that record. I am not sure if I explained
this very well.

Private Sub Next10_Click()
On Error GoTo Err_Next10_Click

    DoCmd.GoToRecord , , acNext
        Me.Method10.Value = _
        DLookup("[Method]", "ReplenishMethodTbl", "[PullSeqCode] = '" & _
        DLookup("[Pull Code]", "MainEntryQrySelectSub1") & "'")

    Me.Signal10 = Blank

Exit_Next10_Click:
    Exit Sub

Err_Next10_Click:
    MsgBox Err.Description
    Resume Exit_Next10_Click
    
End Sub

 

[Remou]

I would guess that DlookUp is returning null. Have you tried stepping through the code?

It may be worth checking the value of
DLookup("[Pull Code]", "MainEntryQrySelectSub1")
separately.

 

[netrusher]

Thans Remou,

I will check this out.

 

[TheAceMan1]

How are ya netrusher . . .

My 1st observation is that the [blue]2nd DLoopUp has no criteria![/blue] Which means it returns the first [blue][Pull Code][/blue] found!

Logically it doesn't appear this is what you want! . . .

[blue]Your Thoughts! . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997