Populate recordsets from query ?

[AngelsGuardian]

Hello all

Im have a table that contains contract that are active or not (tblContract) and a table that contains my every day data for each active contract (tblFldDat). Every day i need to populate my tblFldDat with active contract number. that will result in a nice continuous form that i will be able to fill every day. i need to do that every day (meaning.. repopulate from active contract). BTW... the contract may change from active to inactive everyday. Thats why i need to redo everyday.

My question is...how do i populate a set of records from a list of contract ?

i hope its clear enough cause..i realy dont know how to explain it in another way

 

[MStef]

Hello Angels!

I suggest; make a ContractForm as a MainForm, and
FldDatForm as a Subform.

 

[AngelsGuardian]

The problem with your solution is that i would need to go trough the contract and there is no way i have time for that..i recieve 30 calls in 15 minutes (sometimes more) and i have to make the input fast and easy (lets say lazzzy).

What i realy need is a continuous form with all active contract in front of me so i can put data fast every hour.

so is there a way to make a query from my contract and for each record found in the query(the active ones), create a new record in my Data table.

 

[MStef]

Let me to know how your tables looks like.

 

[AngelsGuardian]

Now i am REALY mad at myself. I figured it out after watching my cats play (Dont ask ;O)

DoCmd.RunSQL "INSERT INTO tblData(DataName) SELECT fldName FROM Table1 WHERE chkStat =0; "

Cant you have more simple then that...
INSERT INTO my everyday table, SELECT the field fldName FROM Table1 WHERE the checkbox status is to 0, meaning active.

Now ill go roll myself in Catnip and ill come back for more coding with you guys later

Thanks for your help !!!