[QUOTE=Bob Fitz;519112]Use:
Code:
Private Sub Form_Current() 'Me.List132.Requery
Me.List132.RowSource = "SELECT GREY_SHADE.OfferID, GREY_SHADE.Shade, GREY_SHADE.Meter FROM GREY_SHADE WHERE (((GREY_SHADE.OfferID)=" & [offerid] & ")); "
End Sub
Now this code is working well please tell which one will be the best among these three.
Code:
Me.List132.RowSource = "SELECT GREY_SHADE.OfferID, GREY_SHADE.Shade, GREY_SHADE.Meter FROM GREY_SHADE WHERE (((GREY_SHADE.OfferID)= " & Me.[offerid] & "))"
Code:
SELECT OfferID, Shade, Meter FROM GREY_SHADE WHERE OfferID=[OfferID];
June's code not working right now.
Code:
Private Sub Form_Current() 'Me.List132.Requery
Me.List132.RowSource = "SELECT GREY_SHADE.OfferID, GREY_SHADE.Shade, GREY_SHADE.Meter FROM GREY_SHADE WHERE (((GREY_SHADE.OfferID)=" & [offerid] & ")); "
End Sub