Form/Subform Adding New Records

  • Thread starter Thread starter Jesse via AccessMonster.com
  • Start date Start date
J

Jesse via AccessMonster.com

I have a form with several related subforms. The ID that links then is
called AuditID and it is created from FORMAT(Now(), "yymmddhhnnss"). My
problem is when I create a new record on the main form it creates one record
on the subform and another when I save it. Why is this? the auditID format
is being assigned at before insert time.

Please help.

because basically for every one record i create in the main I am getting 2 in
the subform only one of which links.
 
How is the relationship setup? Is it enforcing referential integrity? I had
this problem on a project and that was my problem. Another question is what
information is related in the various subforms?

I have one form with 9 different subs but the seperate tables only update if
I enter information into the specifi cells on each included subform.
 
Back
Top