Auto insert records in sub form

[adi32]

I have a form with start date (1/1/03) and end date (3/1/03)
I have a sub form and I want to automate the addition in this sub form 3 records with
dates 1/1/03 2/1/03 3/1/03
How can I do that?

 

[Jack Cowley]

An Append Query should do the trick...

hth,
Jack

 

[adi32]

thank you but how can i do that?
the first form has
code (1)
date from (1/1/03)
date to (3/1/03)
.....


the subform has
code2
code
date
and i want to have the records
1 1 1/1/03
2 1 2/1/03
3 1 3/1/03

 

[Rich]

You'll have to use vba to create the records and update the recordset

 

[adi32]

any ideas?