I’ve been searching online but can’t seem to find something I can use. I’m pretty novice but I can usually break simple examples down to piece together something. What I am trying to do is as follows:
I have two tables and a query with the following relevant fields:
tbl_SHIP: ShipID, TRACKING
tbl_RETURN: ReturnID, SERIAL, ShipFK
qry_EDIT: ShipID, TRACKING, SERIAL, ShipFK
The query is set to filter out all TRACKING records with a valid tracking number, leaving only the ones with a placeholder dummy number entered.
The purpose of this form would be for bulk editing of the ShipFK field in the RETURN records.
What I need is a form with a text control I can scan a serial number into and it will toggle a checkbox to “ON” in the RETURN records. I need to do this multiple times in a session. There also needs to be another control (ideally a combo box) to select a TRACKING record from the query results. Finally, a button should initiate an overwrite of the ShipFK in the RETURN records with the selected ShipID in the combo box.
My thought is to have a main form with the text control and the combo box with a sub-form in datasheet view with the queried records. The workflow would be as follows:
- Select the desired TRACKING record from the combo box.
- Scan the SERIAL data into the text control (from a printed barcode sheet I already have designed. If you need to know, the data is alphanumeric.).
- After each individual scan, the record in subform should be checked. After the record is checked the text control should be cleared in preparation for the next scan. An error should be returned if a record for the scanned serial number does not exist.
- Repeat step 2 as many times as needed.
- After step 3 is finished there should be a button that will overwrite the existing ShipFK in the checked RETURN records with the ShipID selected in the combo box.
The checkbox data is not required beyond the purpose of this specific workflow and the checkbox status should not be stored if possible.
It all seems so simple in my head, but I am starting to think I’m pushing the limits of both myself and Access! Thanks for any and all help!