blank records in a relation table....can't figure out why

Giganews Newsgroups
Subject: blank records in a relation table....can't figure out why
Posted by:  sparks (jstaln…@swbell.net)
Date: Fri, 11 Aug 2006

I am trying to fix a database that someone did about 4 yrs ago in
access97.

The main table just contains demographics and is on the main form of
the database.
It has a subform on a tab that contains the other information.
it is set 1 to 1 in the relationships.

simplify if I can

table 1 and table2

main form table 1

tab
subform table 2

when you create a new record and enter a id number on the main form
and exit.

you have the correct info in table 1 and table 2 has a blank record.

you again put in info in main form and enter data in in the subform.

you have a record in table 1, a record with the linked id in table
to...all looks ok but then I again have a blank record in table 2.

I tried to see if they had some type of requery in the forms or maybe
even some default value or something but it seems that when you add
a record and type in anything in the main form a blank record is
created in the subform table at that instant.. and when you enter
something in the subform a correct linked record is created.
but for the life of me I can't figure out why the blank record is
created in the subform table.

any ideas are greatly appreciated

Jerry

Replies