I'm new to code writing but I understand access pretty well so I will explain as I understand it. I have a database which contains among others one form frm_RSRV. This form contains four controls, [STORE], [PAID], [DATE], [BANK] and 1 command button btn_chk. Also, the database has the following six pdf files (pdfBANK_A, pdfBANK_B, pdfBANK_C, pdfBANK_D, pdfBANK_E and pdfBANK_F) all saved in C:\Monthlypayments\month\Nov2023.......
So far this is what i have used FollowHyperlink "C:\Monthlypayments\month\Nov2023\pdfBANK_A......."
The problem- The above code works and opens only [pdfBANK_A] as specified, I need it to open related pdfBANK_A or pdfBANK_C or pdfBANK_E such that is current in frm_RSRV's control [BANK].
Help please, thank you in advance!!