I am trying to setup a form with a sub from where the only purpose of the sub is to input data without showing any of the previous records.
The idea is to show a list of items that you want to get current counts for. For each item the user opens the record and in a subform enter the counts. The sub forms record will default to the current date and based on the location I have it setup to pre-populate the store. I simply want the the end user to enter a count for the item.
The data that is collected which is counts for items at various locations is used to populate a table for a manager to order items to be shipped to the appropriate location and set the status of that same record to ordered.
The idea is to show a list of items that you want to get current counts for. For each item the user opens the record and in a subform enter the counts. The sub forms record will default to the current date and based on the location I have it setup to pre-populate the store. I simply want the the end user to enter a count for the item.
The data that is collected which is counts for items at various locations is used to populate a table for a manager to order items to be shipped to the appropriate location and set the status of that same record to ordered.