Search results

Thank you very much. So far it looks great! I have a few other things to do around here before I can look at it deeper. I'll let you know if I have any questions. Thank you so much!!

My thinking was that because each case can be referred to the legal department numerous times and we need to track referrals and cases. I need to know if the case has already been referred and if it still has items outstanding, or if (as of the creation of the database) there is no pending...

I was able to figure out autopopulating fields using Pat's many to many example and it works beautifully for existing records, however when I did that, I can't seem to add any new records. I need to add records to my case number combo box and have it update in my subform, so that I can then...

okay, I'm stuck. Why won't the plaintiff and defendant ss# autopopulate correctly. I thought I understood Pat's example, but I guess I didn't. any help?

Yes, thank you, I realize this. I was working on other things in the mean time and it took me a while to get back on the site. I found another thread that seems to have me in the right direction I think http://www.access-programmers.co.uk/forums/showthread.php?t=64963 Pat's sample is proving...

Please help!?! Is what I want to do even possible? or is there an easier or better way to accomplish this? thanks

I have tried so many different solutions to my problem that I think I have just made a bigger mess. I have a database with forms Referral, Case data, plaintiff and defendant. What I want to do is in my form referral, enter the case number and have the case form open to either a new record if...

I'm not sure what type of form I want. I want to enter the Plaintiff SS# in the subform for each referral then I want to know whether or not that plaintiff already exists in the database, view the address and other fields in my Plaintiff Information table to see if the information such as...

openformwithinput is a function that I found that I thought would be helpful, however it seems to have its limitations. I've tried the route using a combobox and onnotinlist event which I think could be helpful, but I unfortunately am not all that familiar with the code that I need and the...

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...