memo field shows last record

[Loni - RWT]

I have a subform on a tab control that only has a memo field in which to
enter descriptive info. When I go to this tab in a new record it shows,
highlighted, the last entry. What causes this and can it be changed? This
memo field is the only one in this table except for the primary and foreign
keys. Another subform on this same tab control which has a memo field along
with other fields shows blank on a new record. I've been unable to see any
differences in the properties.
Thanks!

 

[Allen Browne]

Temporarily add a text box for the foreign key in the subform as well. Does
it show the correct value in this text box as soon as you start typing the
in memo? If not, the main form and subform are not correctly linked.

Open the main form in design view.
Right-click the edge of the subform control, and choose Properties.
In the Properties of the subform *control*, on the Data tab, set the Link
Master Fields to the primary key of the main form, and the Link Child Fields
to the foreign key of the subform.

There was a bug in an old version (probably Access 2000 without any service
packs) where the memo displayed the wrong information if you placed it in
the Form Footer section of a continuous form, but I doubt that's your issue.

 

[Loni - RWT]

Thanks for your help! I found that the form was not linked properly. I'm not
sure why since I dragged it onto the tab control which should have taken care
of the linking. It's working fine now.
I appreciate the help!

 

[Allen Browne]

Good experience.

As you say, the wiz. has a shot at guessing how it should connect the
subform to the main form.

As you found, it doesn't always figure it out correctly.