Re: Subform Troubles

Tech-Archive recommends: Fix windows errors by optimizing your registry

One possible approach:

Check the control source of the subform. You may want to consider a PopUp
instead of a subform. (You can have a command button on the Program Data
Entry Form that will PopUp the new form). The control source of your new form
should be the Swim Lessons Detail table. Set the ParticipantID to allow dupes
in the Swim Lessons Detail table.

You want the new record to be saved in the Swim Lessons Detail table. It will
not store in a table where the ParticipantID field will not allow duplicates.

Although your description was fine, I'd need a snapshot of the DB to continue.
......but I hope this helps.

--
Message posted via http://www.accessmonster.com
.

Quantcast