Just to let you know, I've done a lot with Chat GPT but today I eventually lost patience with its poor talents when it comes to debugging. It is pretty good at coding, has amazing suggestions as how to improve processes but is bad at debugging, it chases its tail, round and round doing the same changes, goes down endless rabbit holes.
So this afternoon I summarised the situation and sent a few screen shots and forms to Claude and hey presto, after 3 or four hours it is working
It seems to have a really good grasp of what Access can and can't do.
As someone else would say, just my 2c worth