Can you out perform ChatGTP?

[LarryE]

Okay folks, I’ve abandoned ChatGPT and built my database myself and I’m amazed I’m only one step away from finishing, so I’m hoping somebody may be able to help. I’m sure you’ll want to tell me I could or should have done things differently, but what I’ve done so works.

The situation is this. I’ve got a Members Form that contains 3 functioning sub forms, but I’m having difficulties with the fourth one because it also contains its own sub form and I’m having trouble linking the two.

The fourth sub form records the member’s Activities – (Activity Name, Activity Date & member age at Activity Date) – Now all of that works in the Members Form but within that sub form I want to add another sub form to record the member’s Partner details. All I need to record are the Partner’s Name and their age at the activity date. I have built a sub form to do that but the problem I’m having is linking it to the member sub form so that each of the members activities can have multiple partners. I have tried several Master/Child links, but nothing works. The sub forms are built on queries from the appropriate Junction Tables.

If you need any images of anything, let me know what you want to see and I’ll post them

Please take a screenshot of your relationship window and copy it into a post so we can see the design.

 

[gemma-the-husky]

If you cant link a form and a subform by using the wizard, you might be able to manually set the linking fields.

Alternatively, in the master form, you can use the current event to set a public global variable to the value of the linking field. Then change the sub form to use the public variable in the query that drives the subform.

So in the master form, in the current event you set the public variable, and then requery the subform, all in code.

 

[CarlettoFed]

I took the liberty of creating an example, to work with it extract the files and open the MembersManagement.accdb file