Duplicating a record and all of its related information in multiple linked bridging tables

[GuysImConfused]

Is it editable directly in the table? Are you adding all the required fields? If it's a linked SQL Server table, does it have a primary key set?

After restarting my PC the table now appears to be editable, but the issue with replicating the records still remains.

SIF TEST V2.1.6.accdb.zip

I've created a button to duplicate my main record, and the information in 4 related junction tables.
Unfortunately, only 3 out of 4 of these junction tables are having their information duplicated.


I am not sure why this is the case, as all 4 segments of code are the same (apart from their variables being changed).
They should all work.


I have included a cut down version of the database with some filler data. If you could take a look I would really apreciate it.


The issue is on the form "DISPLAY_SoftwareConfigurations". The code is an on_click event for the button "Button_Duplicate"
(WIP: Duplicate & Increment Record).


To replicate my issue, you would first select a configuration from the dropdown menu, (select config 1.0.0.0 as this one has associated records in all 4 categories).
Then press the duplicate button. You will notice the new duplicated record only has related records in the first 3 tabs, and not the 4th.


I have tried to diagnose the issue but to no avail, any insight would be greatly apreciated.


Cheers.

[pbaldy]

You've specified the wrong field here:

WHERE EquipmentsConfigId = 75

so no records ever meet the criteria.

I'd also recommend:

http://www.baldyweb.com/OptionExplicit.htm

You've mistyped a variable in that code but get away with it.

[GuysImConfused]

You've specified the wrong field here:

WHERE EquipmentsConfigId = 75

so no records ever meet the criteria.

I'd also recommend:

http://www.baldyweb.com/OptionExplicit.htm

You've mistyped a variable in that code but get away with it.

OMG! This was the issue, I can't believe I missed it.
Thank you so much.

Original issue and all follow-up issues are solved for this thread now.

[pbaldy]

Happy to help! We've all done it.