ACCESS select is runing, insert does not work-CodePudding

The select below runs well:

SELECT szurt.*, *
FROM szurt
WHERE (Forms!start!k1 = FALSE OR [text1] = TRUE)   
  AND (Forms!start!k2 = FALSE OR [text2] = TRUE);

when inserting where the condition does not work:

INSERT INTO int_alapfeladat ( fenntart_tipus, fenntart_megnev,
                            fenntart_kapcs, fenntart_elerhet, om )
SELECT [int_alapfeladat].[fenntart_tipus], [int_alapfeladat].[fenntart_megnev],
       [int_alapfeladat].[fenntart_kapcs], [int_alapfeladat].[fenntart_elerhet],
       [int_alapfeladat].[OM]
FROM szurt
WHERE (Forms!start!k1 = FALSE OR [text1] = TRUE) 
  AND (Forms!start!k2 = FALSE OR [text2] = TRUE);

Prompts for a parameter in a pop-up window, miért... help:( /it would be nice to help with some example code/ THX.!!

CodePudding user response：

Try with:

INSERT INTO 
    int_alapfeladat 
    ( fenntart_tipus, fenntart_megnev, fenntart_kapcs, fenntart_elerhet, om )
SELECT 
    [fenntart_tipus], [fenntart_megnev], [fenntart_kapcs], [fenntart_elerhet], [OM]
FROM 
    szurt
WHERE 
    (Forms!start!k1 = FALSE OR [text1] = TRUE) 
    AND 
    (Forms!start!k2 = FALSE OR [text2] = TRUE);