Auto fill field not saving to table

[JeRz]

Hi All,



I have a DB with 2 tables: tblFamily and tblIssues. When adding a new issue, the user clicks on a button which then brings up a form named FamilyFind. Within that form, a subform named tblFamilysubfrm displays. I have a dbl click event set to open a form called NewIssue when a user double clicks on the PatientID field within the subform. From there, the user enters the detail of the issue. However, I am attempting to get the MemberID and PatientID to carry over to the NewIssue form from the subform.

The control sources for the MemberID and PatientID fields on the NewIssue form are currently set to the record source for the table. I am attempting to add code to the On Load event of the NewIssue form so that when the user double clicks on that specific PatientID within the subform, it will load the PatientID so they do not have to re-enter it. However, I keep getting errors when trying to do this.

I have tried removing brackets where there are no spaces and have tried moving things around but to no avail. Here is what I have currently:

Me.PatientID=Forms![FamilyFind]![tblFamilysubfrm].Form![IDNumber]

Can someone assist? I can provide additional info if needed.

Thank you!

[RuralGuy]

How about using the OpenArgs argument of the OpenForm command? http://www.baldyweb.com/OpenArgs.htm

[JeRz]

How about using the OpenArgs argument of the OpenForm command? http://www.baldyweb.com/OpenArgs.htm

Thanks for providing this! Worked great!

[RuralGuy]

That's great! I marked this thread as *Solved* for you using the *Thread Tools* at the top of the thread.
https://www.accessforums.net/showthread.php?t=1828