I've been working this issue for several days, I've searched this forum and others and I'm sure I'm not searching on the proper keywords for a solution.
I have a form that allows the user to input a medical record number. The subform (datasheet view) then returns all admission records for that patient.
I would like to give the user the ability to select an admission record from the subform and open a form that would allow the addition of an event to that particular admission. To do this I need to be able to pass the Medical Record number originally searched and the selected Admission Record Number selected on the subform.
I've been successful in capturing the Admission Record Number but when I attempt to capture the Medical Record number I get an error stating I can not reference an object that does not have focus.
I do not have enough posts to attach my project. But if it will help, please let me know and I'll be happy to zip it and send it to be approved for posting.
I'm really just hoping that someone can point me to a thread that has covered passing values from one form to another. Not looking for someone to do the leg work, just need someone to point me in the right direction.
Thanks in advance,
Bart
I have a form that allows the user to input a medical record number. The subform (datasheet view) then returns all admission records for that patient.
I would like to give the user the ability to select an admission record from the subform and open a form that would allow the addition of an event to that particular admission. To do this I need to be able to pass the Medical Record number originally searched and the selected Admission Record Number selected on the subform.
I've been successful in capturing the Admission Record Number but when I attempt to capture the Medical Record number I get an error stating I can not reference an object that does not have focus.
I do not have enough posts to attach my project. But if it will help, please let me know and I'll be happy to zip it and send it to be approved for posting.
I'm really just hoping that someone can point me to a thread that has covered passing values from one form to another. Not looking for someone to do the leg work, just need someone to point me in the right direction.
Thanks in advance,
Bart