Insert into subform

[jaryszek]

Hi it is possible to inserrt into subform from main form?



I have form like belowe:



If user will use magic wand button all data from main form should be inserted into subform.

Subform name is frmQry_Daty_status

I am trying to write an sql statement:

INSERT INTO Form_frmQry_Daty_status(Data_Korekty, Kwota_korekty, Liczba_raportow, Cause_ID_FK) VALUES(#2014-03-01#,199,2,1)"

but there is an error:

table "Form_frmQry_Daty_status" cannot be found.

how i should do it?

Create query, use it as subform source and use insert into than?

When user chooses for example date from 2017-08-06 to 2017-09-28 database have to insert to rows into subform.
With date 2017-08-01 and second with 2017-09-01. And that is why i have choosen VBA to insert values.

Please advice,
Best Wishes,
Jacek Antek

[ranman256]

just run an append query. The data will show in the subform after you refresh it....

docmd.openquery "qaAddData2Subform"
me.subform.requery

[jaryszek]

Thank you ranman256 !!

Jacek