Quick one! Automatically add a record

[jk12]

Hi all, here's my problem. Within my form I have some tabs with subforms on them based on various tables. What I would like to know is if there is a way that when I add a record to one of the subforms, a blank record is automaticlly added to the rest of the subforms.

Thanks

 

[neileg]

Why do you want blank records?

 

[KeithG]

you could set focus to the subforms and use docmd.gotorecord,,,acnew but I also don't understand why you would want blanks records.

 

[jk12]

a blank record was a bit misleading. I want the record to automatically be added because some fields pull in information from other tables so they wouldn't really be blank records

 

[gemma-the-husky]

I would have thought if your forms are properly linked you shouldn't have to do anything. Adding data anywhere should automatically be reflected in the data displayed in other forms. However if you are using unbound forms, then you may want to refresh or requery some of those.

from a subform you can do this be

me.parent!subform1.requery

the forms reference syntax gets quite complicated depending on what you want to do, though.