Create a form to represent inventory drawer locations

Hello. I am trying to remember how to do this, as I did it once (but erased
my work

I have a table that contains data about parts inventory. Here is a sample

PartNumber Location
-------------- ----------
123-abc as-1f-1a
123-def as-1f-1b
123-ghi as-1f-2a
123-jkl as-1f-2b

The way to read a location is as = department
1f = storage cabinet 1, 6th drawer
down (as f is the sixth letter)
1a = row 1, on the left of the
drawer, compartment a (in the front of the drawer)

What I am trying to do is create a form that would look like this. I t
would read the drawer location and assign the part number for that location
in a text box on the form. I hope this isn't too vague....