Best approach to reworking a data entry form? - 06-06-2012 , 04:34 PM
I'm an occasional Access user using A2007 and have a database with the following relationship (a star around tblMaster):
tblMaster - CaseID(K), status, name date started, etc.
O:M with tblSubwork - CaseID(K), SubworkID(K), employee, date assigned, etc..
O:O with tblAttorney - CaseID(K), name, date assigned, etc.
O:M with tblFacility - CaseID(K), FacID(K), address, etc.
O:O with tblDisposition - CaseID(K), disposition type, date of disposition
I have a working data entry/edit form with a series of subforms that workedfine while I was the only user of the database. I'm told that my positionis being downsized and I need to hand the database off to someone else who's never touched Access before.
I want to create a new data entry form with tabs in place of the former subforms that can be used for entering new Master records and editing past entries. One tab would be for the information in tblMaster and tblFacility, the next with a subform for tblSubwork, etc. Each tab would have the CaseID, Name, and Status across the top (so my coworker won't have to switch backand forth to see what he's working on).
My older, working form used the tables as control sources, but for some reason when I added tab control to a copy of it and moved the subforms to their proper places, the subforms I had been using for the last few tables no longer "remember" which CaseID they're supposed to be associated with.
I tried creating a query as the control source but it is uneditable (I presume because there are no records in tblSubworker or tblFacility for some ofthe CaseID).
I created this database so long ago that I've forgotten why I did things the way I did them and I don't have enough time to redo it. As the subject implies, I'm looking for an approach, not "the answer." My plan was to create a switchboard with this form, some simple reports and a few queries as buttons and hand it off but it's not going very well and, well, I'm a littledistracted.