find record more table

[nicolareina]

good morning everyone.
I will briefly explain my problem.

HELP



in my database I have 2 tables (TBL_1 and TBL_2)

In the "Lista Sottoposti" form I asked if there was the possibility of finding the records in TBL_1 and TBL_2.

Once the record is found, clicking on the "Open" link will open the "Dettaglio Sottoposto" form

I have already tried with a union query, the problem arises that when in TBL_1 and TBL_2, there is a person with the same ID, then clicking the open button gives me an error.

https://file.kiwi/3380d814#kImxqZmADdGD5Ih7lvgv0A

Download Example.accdb

Sorry max file size attachement 500,000 Kbyte

[jojowhite]

I can't believe you have 191 fields on Each tables.
no wonder you cannot create a Union query.
you need to break Wide table into smaller, narrow tables.

[Welshgasman]

Crossposted first at https://www.access-programmers.co.uk...-table.334223/