Ashleylinkewich
New member
- Local time
- Tomorrow, 07:26
- Joined
- Feb 13, 2020
- Messages
- 1
Hi!
I am looking to revamp our maintenance database and transition from excel spreadsheet to database, PBI, etc.
I have created a form where operators can input maintenance requests. They input DATE, RAISEDBY, MACHINE, and DESCRIPTION. There is a key ID created as well for this request.
I want to create an additional form called "Request Lookup" for maintenance managers where they can use a combo box to select the ID from the reqest, and automatically have the DATE, RAISEDBY, MACHINE, and DESCRIPTION autofill for the request associated with the ID.
From there, I want them to have the ability to fill out additional fields (RESPONSIBLE, TASK, PARTSREQ, LABOURCOST, STATUS, etc.) and update the entry in the table.
So far, I have tried almost every variation of afterevent and DLookup, but I'm at a loss. VBA isn't my forte and I only started using Access 3 days ago.
I so so appreciate your assistance on this!
I am looking to revamp our maintenance database and transition from excel spreadsheet to database, PBI, etc.
I have created a form where operators can input maintenance requests. They input DATE, RAISEDBY, MACHINE, and DESCRIPTION. There is a key ID created as well for this request.
I want to create an additional form called "Request Lookup" for maintenance managers where they can use a combo box to select the ID from the reqest, and automatically have the DATE, RAISEDBY, MACHINE, and DESCRIPTION autofill for the request associated with the ID.
From there, I want them to have the ability to fill out additional fields (RESPONSIBLE, TASK, PARTSREQ, LABOURCOST, STATUS, etc.) and update the entry in the table.
So far, I have tried almost every variation of afterevent and DLookup, but I'm at a loss. VBA isn't my forte and I only started using Access 3 days ago.
I so so appreciate your assistance on this!