problem with 2 subforms to create new data entry at top of form

[Laurie]

I used the advise from this forum to force new data entry at the top of a
form. I created 2 subforms - one set to single record, New Data Entry=Yes
for entering new records. The other form is set to Allow Additions=No to
display all existing records. Both are linked to the Main Form via Item
Number.

When the form opens, everything looks fine (the main form opens to a blank
record). However, when I select an actual Item Number on the Main form, the
"data entry" form displays the first record for the selected item - which is
then repeated in the form below.

I tried eliminating the Master/Child link to the data entry form and simply
making the default setting for the Item Number control to the value from the
main form. Now the form is pulling the first record on the entire table.

 

[Jeanette Cunningham]

Laurie,
Wouldn't you make the data entry form with its Data Entry property is set to
Yes?
If you do this, this form won't show any records and will open at a new
record.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Laurie]

The Data Entry property for the data entry form IS set to Yes.

 

[Jeanette Cunningham]

Laurie,
here is a link to a sample.
This sample illustrates two ways to have a continous form with the new
record on top. The first method uses unbound controls in the header of the
form and the second uses a bound subform set to Data Entry.

here is the website
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=374

See if this helps.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia