PaquettePaul
Member
- Local time
- Today, 15:39
- Joined
- Mar 28, 2022
- Messages
- 107
My prior response seems to have dropped into the ether. Oh well.
I had a similar problem with a continuous form where I wanted to click on a sub form record to cause a form to be opened. I thought of check boxes and buttons but they did not work. The simplest solution for me was to switch the sub form’s Record Selector property to Yes. With that, a button appears in front of each record in the continuous form
i created a VBA process for the OnClick event that saved the selected record’s primary key. At that point, you could open your form
In my case, I had multiple options including opening another form. I put the required options as buttons in the sub form’s footer. That way the user clicks on the record selector button for the desired record (where the record key is saved in a global variable), and then clicks on the option button in the footer, where the VBA code could open a form or do any other desired action.
I had a similar problem with a continuous form where I wanted to click on a sub form record to cause a form to be opened. I thought of check boxes and buttons but they did not work. The simplest solution for me was to switch the sub form’s Record Selector property to Yes. With that, a button appears in front of each record in the continuous form
i created a VBA process for the OnClick event that saved the selected record’s primary key. At that point, you could open your form
In my case, I had multiple options including opening another form. I put the required options as buttons in the sub form’s footer. That way the user clicks on the record selector button for the desired record (where the record key is saved in a global variable), and then clicks on the option button in the footer, where the VBA code could open a form or do any other desired action.
