Help With replace Function

[JBurlison]

So im Trying to automaticly change the location of a product when it is received. here is what i have so far im confused as to how the replace function works. i want to replace "Location" on the "Main Inventory" table according to S/N. here is what i have so far.

Private Sub Command73_Click()

If IsNull (Me.Sai_Serial_Number_1r.Value) OR Me.Sai_Serial_Number_1r.Value = "" Then
   
   Else
   
    If Me.Sai_Serial_Number_1r.Value = DLookup("[Sai Serial Number]", "[Main Inventory]", "[Sai Serial Number] = '" & Me.Sai_Serial_Number_1r & "'") Then
    
      Replace () ' no Clue how to use this function
    
End If
   
   
End Sub

im not sure how to lookup the the correct row to replace the location on. the primary key is the "Sai Serial number".

 

[RuralGuy]

The Replace() function is used on strings to replace a character with another character. Have you looked up Replace() in VBA help?

 

[JBurlison]

na it was no help at all

 

[ajetrumpet]

Hey Allan,

I have a feeling we'll be working on this DB for a while...
http://www.access-programmers.co.uk/forums/showthread.php?t=145785

and JB, just by pure "happenstance", any function you look up in Access help will state explicitly the input of the function, output of the function, attributes of the data, and data types involved in the process. That should at least tell you weather or not you have the right one to work with....