Loosing master:child links in form:subform

  • Thread starter Thread starter raye
  • Start date Start date
R

raye

I have a fairly complex database with approx 6 users.
I have created a master form that has a tab control placed on it. In each tab
I have placed a subform and have set the Master\child links. Intermittently
the master form will loose the links between one or more subforms.

On many ocassions if the user exits the form and comes back in the link will
be back in place, however sometimes the link is universally lost and I have
to go in and reset it.

Have you had this experience and what can I do to avoid it?
 
Suggestions:

1. If you are programmatically assigning the SourceObject of the subform
control, or the RecordSource of the main form or subform, Access will have a
guess at what you want for the LinkMasterFields/LinkChildFields. You must
re-assign these properties yourself if you change SourceObject or
RecordSource.

2. Make sure the database is split, so all users have their own local copy
of the front end, and do not interfere with each other. If this is a new
concept, see:
http://allenbrowne.com/ser-01.html

3. Use an MDE for the front end you give your users. This will stop them
fooling with the design, and also stop it from decompiling.

4. Make sure the Name AutoCorrect boxes are unchecked under:
Tools | Options | General
Explanation of why:
http://allenbrowne.com/bug-03.html
 
Back
Top