Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
FORM RECORD SELECTORS GET LOCKED
- Thread starter SeanB
- Start date
Guest_imported
New member
- Jan 1, 1970
- 0
Is the form based on a single table or query?
If the record source of the form is spanned over multiple tables, any blank fields within the form could disallow the referential intergrity of any relationships to save the data. If this is the case, to test this theory, at the point where you cannot navigate records, press the escape button. Although this will undo any data entered, if it allows you to continue, it is likely that the integrity of a relationship is being breached.
See how you get on...
If the record source of the form is spanned over multiple tables, any blank fields within the form could disallow the referential intergrity of any relationships to save the data. If this is the case, to test this theory, at the point where you cannot navigate records, press the escape button. Although this will undo any data entered, if it allows you to continue, it is likely that the integrity of a relationship is being breached.
See how you get on...
LonnieJohnson
Programmer
Is the DataEntry property set to Yes? ljprodev@yahoo.com
ProDev, MS Access Applications
ProDev, MS Access Applications
- Status
