FollowHyperlink to open a pdf file related to the record in an open form

[Datament]

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

[June7]

Concatenate variable reference. If .pdf is not included in the saved text, concatenate it.

FollowHyperlink "C:\Monthlypayments\month\Nov2023" & Me.Bank & ".pdf"

[CJ_London]

What does your [bank] control actually contain as it should only contain 1 file name. And show the code you are using to open the pdf since as described, nothing should open. Also what type of control is [bank]?

[Welshgasman]

Probably more like

FollowHyperlink "C:\Monthlypayments\month\Nov2023\pdfBANK_" & Me.Bank & ".pdf"

if I understand the question correctly.

However I can see problems when it comes to Dec 2023 payments?, so that will need variables as well?

[Datament]

Yes [bank] control contains only 1 file name at a time. And the control is a textbox. This is the code I am currently using to navigate to that folder FollowHyperlink "C:\Monthlypayments\month\Nov2023" & Me.Bank & ".pdf".

There are four files [pdfBANK_A, pdfBANK_B, pdfBANK_C, pdfBANK_D] in the folder named Nov2023. I need to navigate to the folder Nov2023 and open file pdfBANK_C since this file is the only one that is open in control [BANK]

[Datament]

Yes, you are right. In the AP that Nov2023 has been replaced with [PROC]. And it will not require additional variable in the future.

[BANK] control contains only 1 file name at a time. And the control is a textbox. This is the code I am currently using to navigate to that folder FollowHyperlink "C:\Monthlypayments\month\Nov2023" & Me.Bank & ".pdf".

There are four files [pdfBANK_A, pdfBANK_B, pdfBANK_C, pdfBANK_D] in the folder named Nov2023. I need to navigate to the folder Nov2023 and open file pdfBANK_C since this file is the only one that is open in control [BANK]. The folder Nov2023 is now [PROC]

[Welshgasman]

FollowHyperlink "C:\Monthlypayments\month\"  & Me.Proc & "\" & Me.Bank & ".pdf"

Personally it seems the folder month is not needed ?, so .......

FollowHyperlink "C:\Monthlypayments\"  & Me.Proc & "\" & Me.Bank & ".pdf"

[Datament]

Thank you Welshgasman. The second code worked perfectly.