juliewhite
Registered User.
- Local time
- Today, 10:14
- Joined
- Aug 30, 2004
- Messages
- 10
I am trying to create a database for a legal department. we want to track the cases that pass through our office. my biggest problem so far is coming up with a solution to edit and or add a record. I am working through a from called Referral Information. In it I have a subform with the Case Number and Plaintiff and Defendent Social Security numbers. What I would like to do is when the user enters the plaintiff social security number the form Plaintiff Information is opened either to the existing information to update the records or to a new record. I thought I had it figured out once using the function openformwithinput, but when I tried to do the same function to the defendent social security number, I was given an error because it was referring back to the form Plaintiff Information. I didn't think this would be this difiicult. Help me, I don't know where to look or what to try anymore.
Once we have established a case with the courts, the plaintiff and defendent for that case never change, however, the case can go to court an indefinite number of times.
Once we have established a case with the courts, the plaintiff and defendent for that case never change, however, the case can go to court an indefinite number of times.