I would like to use a form to create a list of records for each day of the month. I would use a drop down box for department, area and item. A begin date would be selected, the dept, area then item. A set of records would be created for each item to list the date, dept, area and item for each day of the month. Additional fields in the table would be added using a PDA then uploaded back to the table. I am using Handibase to upload the data back to Access. We are currently using Excel to fill out the form then importing it into Access. I would like to use Access because a field for replacement item is checked using a query of approved replacement items using a lookup field.
create a monthly list
- Thread starter lbeham
- Start date
