Hello. I have an Access database that I need to build a form in that users can use to update data in a selected table. Here is the criteria I need to meet...
We have a number of tables in the database, each one specific to a certain size label we print here... so our 2x1 labels have a table, our 3x2 labels have a table, and so on. Each one of these tables contains all of the information specific to the different item numbers in it. So in our 2x1 table, we have a column for a item #, and then the columns related to that item number, like Quantity, Description, Location, etc.
We are looking for a single form that a user can use to update fields by selecting the table name and entering an item number first. This would bring up all of the editable fields specific to that item in the form. They make the changes in the form to the item, then use a button to update the field.
I am very VERY new to Access and I need help with doing this. Any help would be greatly appreciated.