Form's toggle button not pulling up subform as intended

[Ahdr16]

Hello - I am an Access/VBA coding newbie who's been tasked with troubleshooting an Access database issue at work.

I am working with an Access 2007 db (Windows 7 o/s/32-bit). There are two Forms I'm working with:


1) FIRM
2) Firm RFP Entry subform

The FIRM form has a toggle button entitled "RFP". When clicking the RFP button, we want to achieve the following:
1) open the "Firm RFP Entry subform" Form and
2) open to the Firm Name that is currently pulled up in the FIRM form

However, when we click the RFP button, it thinks (hourglass) for a few seconds and nothing happens.

I've been searching online for several hours, trying to figure out what the problem is with the underlying VBC code, but I haven't found a solution. I wanted to provide the entire VBA code string from the RFP toggle button here, in the hopes that someone could advise as to how we can fix the issue. I have attached a text file containing the code. If anyone can assist, I would be extremely grateful. Thank you for your time and expertise.

[CJ_London]

you say your toggle button is called RFP - but there is no code associated with it

[Ahdr16]

Thank you for your response -- we were able to solve our issue by adding DoCmd.OpenForm "Firm RFP Entry subform" to the code and linking the two forms via the Firm ID by modifying the second form's Expression Builder field.

Thanks again for your help -