Autofill Form from Same Table

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 was a heavy user of a CMMS type application that among many other things, included Work Requests. To search work requests (or similar things such as work orders) it had a form with a list box. That was a table list of search types and selection of a search from the list (it was a descriptive term such as "Search by equipment location, Required by Date; Creator etc.) and choosing an option displayed the applicable fields for entering search criteria. Upon button click, the sql was generated an applied to the applicable tables. It's really just a type of search form but perhaps a bit more elaborate than this one.

Depending what the process is that you want to support, you may find this to be a fairly complicated project.
 
Welcome to the Forum!

Sounds like you want to put the same information in Table 2 that is in Table 1 which is not normal. Perhaps it would to start from the beginning. Can you post a screen shot of your Relationships window? This will help to make sure you first have your Tables set up correctly.
 
@Ashleylinkewich; I guess you'd better clarify what you mean because it seemed to me that you only want to pull up partially completed records (if that's what you mean by autofill according to request ID) and then complete them. If you're duplicating records I totally missed it.

EDIT - None of that depends much on DLookup or vba code, btw. A bound form will do the job.
 
Research a subject called "Normalization" a database works a lot different from a spreadsheet.
Try to forget anything you think you know about excel and stop applying it to a database.

Come back with any questions.
 

Users who are viewing this thread

Back
Top Bottom