Probably a siple question

[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

 

[Evi]

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