Software

Ask something
Discussion Locked

Access 97 SubForms

0 helpful
3 replies

by bowjangles

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Hi, i have many forms that use subforms in my application. When using subforms i have 2 problems. First, when i try to set focus from an object on one Subform to that of another on the same form it does not work. Reason for doing this is so my tab order will work correctly. Second, when i close the form, if no data was entered on a subform, a blank record is saved and im having trouble trying to prevent this. Any help on these topics would be greatly appreciated. Thanks

3 replies

by nangsw

Maybe these can help you:
1. Delete your subform, then make again.

2. If still happen like that, please, select the subform then "VIEW-PROPERTIES" and make sure in "Data" Tab that the "SOURCE OBJECT" is the subform name.
"LINK CHILD FIELD" is the fieldname of subform that has joint with parentform.
"LINK MASTER FIELD" is the field name of parentform that has joint with subfom.

3. Select "TOOLS-RELATIONSHIP" and make sure the table that make the master form and sub form are joint.

by bowjangles

Even when i code the tabs to setfocus to another object in the On_Lost_Focus function, it does not work. It also saves blank records but just to the table which is linked to the SubForm.

This discussion is closed to new replies.