Problem with adding new rec with form containing a subform
I guess the easy way to do it is to redesign your table. Based on your
information, you should split one table into two: Table 1: ISN, ACCTNO.
Table 2: ACCTNO, DATA1, DATA2. Then, you can bound your main form to
Table 1 and your sub form to table 2. Since there is one to many
relationship between table 1 and table 2, You can do the add/edit
process as you described.
Hope it will help.
Quote:
> -----Original Message-----
> Posted At: Tuesday, July 13, 1999 12:16 PM
> Posted To: forms
> Conversation: Problem with adding new rec with form
> containing a subform
> Subject: Problem with adding new rec with form containing a subform
> I have a table with the following fields:
> ISN (autonum - primary key), ACCTNO, DATA1, & DATA2.
> ACCTNO - can be repeated with different DATA1 & DATA2.
> I have created a FORM that has only ACCTNO displayed at the
> top. Below
> the ACCTNO,
> in the same FORM I have added a SUBFORM that contains DATA1 &
> DATE2. The
> SUBFORM
> is a continuous repeating form that display DATA1 & DATE2 for
> each ACCTNO.
> Now because I wanted to be able to scan through each acctno grouped
> together, I made a query
> to find all of the UNIQUE acctnos. Once I did this, the
> button ">*" that
> prompts new acctno record
> updates was no longer clickable. Within each acctno subform,
> new records
> can be
> added that way but no new acctno records. Do you know how I
> can add a new
> acctno record ?
> Thanks,
> Brent Dixon
