How to query all the ID of the first table with the last Event and the first Date on the second table related one-to-many to the first?

I'm trying to retrieve from two tables related one-to-many (Subattivita.ID-Eventi-IDSubattivita), some fields from first table and two other fields to the second table (last Eventi.Evento and first Eventi.DataInserimento).

I don't know why I get an error with the following SQL query. Can someone help, please?

First Table: Subattivita

Second Table: Eventi

Required results of query:

I've tried with the following SQL query, but Access asks to enter the u.Evento value:

SELECT 
    t.ID, 
    u.Evento as LastEvento, 
    p.DataInserimento as FirstDataInserimento
FROM 
    ((Subattivita t
INNER JOIN 
    (SELECT IDSubattivita, MAX(ID) as MaxID FROM Eventi GROUP BY IDSubattivita) u ON t.ID = u.IDSubattivita)
INNER JOIN 
    (SELECT IDSubattivita, MIN(ID) as MinID FROM Eventi GROUP BY IDSubattivita) p ON t.ID = p.IDSubattivita);

That's not an error message. It is a prompt from query for input of value because query references field(s) not in dataset - as noted by @TimRoberts. Looks like you want the Min(DataInserimento) for each IDSubattivita. Pulling Evento associated with maximum ID for each IDSubattivita is more complicated. Consider:

SELECT Q.IDSubattivita, Evento AS LastEvento, FirstDataInserimento FROM Eventi INNER JOIN 
    (SELECT Eventi.IDSubattivita, Max(Eventi.ID) AS EID, 
     Min(Eventi.DataInserimento) AS FirstDataInserimento FROM Eventi
     GROUP BY Eventi.IDSubattivita) AS Q 
ON Eventi.ID=Q.EID;

Or this version:

SELECT Subattivita.ID, Contenuto, 
   (SELECT TOP 1 Evento FROM Eventi AS Dup 
    WHERE IDSubattivita=Subattivita.ID ORDER BY ID DESC) AS LastEvento, 
   (SELECT TOP 1 DataInserimento FROM Eventi AS Dup WHERE 
    IDSubattivita=Subattivita.ID ORDER BY ID) AS FirstDataInserimento
FROM Subattivita;