Changing Field Values with Command Button

[avarusbrightfyre]

I am using Access 2007 to create an inventory of serialized items. I have a main "Items" table that stores all of the information on the gear. The relevant fields for this question are the "Serial#" and "Location" fields. Each item has a unique serial number stored in the "Serial#" field, and it's current location is stored in the "Location" field. The "Location" field will also be used to show whether an item has been issued to someone, and will store the name of that person in the field instead of an actual location.



The problem with this is that I want to make a very simple way of changing this information for the end user. I have a tabular form that displays every item that is assigned to a specific person, and I have an "Add" button which brings up a form that will allow the user to type in a serial number in a text box.

So my question is: How do I change the "Location" field of a specific serialized item?

[pkstormy]

My guess (without fully understanding your question or setup), is that you could design an update type of query to update the "Location" field using criteria to match the serialized item selected on the form (ie. criteria such as = Forms!MyFormName!SerialNumber for the serial #). But I really don't understand your question or what exactly you're trying to do. I'm 'guessing' this is what you're trying to do.