Probably a siple question

  • Thread starter Thread starter JBurlison
  • Start date Start date
J

JBurlison

i want the location to change on an item when its item number is brought into
receiving, So i want the location to change to "floor" everytime i receive
its item number this is what i have thus far:

If 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

'this is where i cannot figure out how to change the Location, the form
name is Main Inventory and the location field is "location". i want location
to change to floor every time someone clicks the button.

Else

End If

End If
 
Depending on what you mean by 'when its item number is brought into
receiving' the relevant line of the code will be

Me.Location = "Floor"

Evi
 
Back
Top