Ask a Question related to Microsoft Access, Design and Development.
subforms within subforms
I've got a form1 that has a subform1 and that subform1 has
a subform2 linked to it. Both relationships are one-to-
many. These forms and subforms are working fine. My
problem is that I want a subform3 linked to the subform2
and I've tried it but everytime I try to enter data into
the subform3 and close the subform3 it tells me that "I
cannot add or change a record because a related record is
required in the subform2".
I don't understand why because I've got a record in
subform2. That's where I would double click the subform2
record to enter notes in the subform3 (This is only a
notes table for each specific record in subform2). The
only difference between the forms that are working from my
description in the beginning is that the subform2 is in
datasheet view. I tried it in form view as well and it
didn't work. Is the problem the linked fields or what?
On Wed, 20 Aug 2003 17:15:09 -0700, "Chris" <com> wrote: >The middle section has a set length of 16 rows. I just want >to show those sixteen...
Novice here ... need help with creating a sub-form. I have 2 tables and Forms Main List Table, Event Table Main List Form, Event Form I am...
Thanks Terrell, I don't have a horizontal scroll bar but I do have a vertical bar. When I move the focus to a field and change subforms with the...
Im relatively new to Access and could use some help. I'm using Access 2002 and have two subforms (both datasheet views) on a main form. I want...
Ok - I might be going about this completely the wrong way, but here goes! I have an order entry Database - Access 97 I have form that has 2...