Hi All
I have a main form that has a sub form on it. I want to have the user enter the main form and when they enter main form or sub form, automatically add 5 new records in the sub form with one of the fields filled out. Would it be better to add when entering the main form or wait till the user tabs to the sub form?
Basically I have to auto insert into sub form. I am wondering what would be the most efficient way to do this. Which way would be best for performance?
I was using validation to make the user go back and fill out any missing categories from the 5 mandatory categories upon saving, now the request is that it auto insert all 5 categories upon entering main form or sub form in a specific order every time.
I am hoping this can be done with an insert into statement on sub form gotfocus event?
Any help is greatly appreciated.
Thanks
Raven
I have a main form that has a sub form on it. I want to have the user enter the main form and when they enter main form or sub form, automatically add 5 new records in the sub form with one of the fields filled out. Would it be better to add when entering the main form or wait till the user tabs to the sub form?
Basically I have to auto insert into sub form. I am wondering what would be the most efficient way to do this. Which way would be best for performance?
I was using validation to make the user go back and fill out any missing categories from the 5 mandatory categories upon saving, now the request is that it auto insert all 5 categories upon entering main form or sub form in a specific order every time.
I am hoping this can be done with an insert into statement on sub form gotfocus event?
Any help is greatly appreciated.
Thanks
Raven