master/child links missing in 97 to 2K conversion

G

Guest

after converting Access97 to 2000, the forms/subforms do not point to the
correct records after performing a filter. The form has to be closed, then
the pointers are correct. I have researched that the master/child links need
to be configured correctly but, when viewing the properties of the form or
subform, there are no master/child link properties. What is the fix for
this??? Thanks in advance, Jim.
 
A

Allen Browne

To find the LinkMasterFields property:
1. Open the main form in design view.
2. Right-click the edge of the subform control and choose Properties.
3. Look on the Data tab of the Properties box.

If you are applying a Filter to the main form, as well as a Filter to the
subform (as well as any LinkMasterFields/LinkChild fields), Access gets
confused. More info:
Incorrect filtering of forms and reports
at:
http://allenbrowne.com/bug-02.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Master/Child Links to Subforms 1
Problem with Link Child and Master Fields 7
2 Subforms, one master 2
Master/Child linking in code 8
Records do not show in subform 4
Master/Child Fields - Subforms 1
Link Child/Master Fields from Three Combo Boxes in Subform 2
Link Master and Link Child Problem 13

Top