I have a main form (LOA-ReAdmit) containing two subforms (LOA and ReAdmit) and each subform contains a subdatasheet form.
The subforms and the subdata form work like they should when you select an id hyperlink in the subdataform to fill the subform when only the LOA or ReAdmit form are open.
When you open the main form (LOA-ReAdmit) and select an id in the datasheet it fills the first record no matter which is chosen. So i choose record three and it fills record 1.
I have attached a screen grab of the forms in both modes
and the macro that makes the subdata form and the subform work.
I did try adding the hidden fields LOA and ReAdmit to the main form to see if that would work but it made no difference.
any help on getting this to work from the main form would be appreciated. :banghead:
The subforms and the subdata form work like they should when you select an id hyperlink in the subdataform to fill the subform when only the LOA or ReAdmit form are open.
When you open the main form (LOA-ReAdmit) and select an id in the datasheet it fills the first record no matter which is chosen. So i choose record three and it fills record 1.
I have attached a screen grab of the forms in both modes
and the macro that makes the subdata form and the subform work.
I did try adding the hidden fields LOA and ReAdmit to the main form to see if that would work but it made no difference.
any help on getting this to work from the main form would be appreciated. :banghead:
