Subform linking problem

[mattieflo]

Hi,

I have main form (Employee) linked to a subform (Email). That subform
(Email) is the parent of another subform (Order). An employee can have many
emails and an email can have many purchase orders on it. In any case, the
email subform and the order subform are both continous forms and the email
subform requeries the order subform with its On Current event.

The problem im having is when I move to an Employee record that should have
no email or order information, instead of having the primary key of the email
subform show up as (AutoNumber) on the form, it is automatically generating
an a record on the first line. For example instead of looking like this when
you flip to an empty employee record:

ID Email

(Autonumber)

It looks like this

ID Email
* 51

(AutoNumber)

This starts to happen when I create the link between Email and Order. Does
anyone know why its automatically assigning this number when the user hasn't
clicked on that record yet?

 

[KARL DEWEY]

The ID autonumber is probably the Master/Child link between Employee table
and E-mail table. Just do not display it.

 

[mattieflo]

Hi Karl,

No dice....I'm still getting the phantom record. it simply displays the
record without the ID field.

 

[KARL DEWEY]

Does it display an asterisk to the left of the first field and all fields
empty? If so, this is normal.

 

[mattieflo]

Actually it shows the pencil next to the first record and the asterik on the
next line. I'm not sure why its automatically trying to write to that first
record....