[AccessD] Subform problem with detail section

Finally...
   You should have a  Linked ID between the Parent Form and the
Subform. Typically something like

tbl_Orders Field: PKOrderID

tbl_SubformTable Field: FKOrderID, PKID

the Linked ID would be the OrderID.  Checking the properties of the
subform, you should see the linked table field to be the OrderID


On Wed, 1 Sep 2004 14:43:21 -0500, Kaup, Chester A
<kaupca at chevrontexaco.com> wrote:
> Added the primary key but text boxes and list boxes in the detail
> section do not display.
> 
> Chester Kaup
> Information Management Technician
> IT-MidContinent/MidContinent Business Unit
> CTN 8-687-7415
> Outside 432-687-7414
> 
> No trees were killed in the sending of this message. However a large
> number of electrons were terribly inconvenienced.
> 
> 
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Francisco
> Tapia
> Sent: Wednesday, September 01, 2004 1:47 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Subform problem with detail section
> 
> It is my opinion, that you should have a PKID of some sort for table you
> are adding records, if not a Surrogate Key, then at the very least a
> Natural Key.  either is bether than NO key :D
> 
> On Wed, 1 Sep 2004 13:26:29 -0500, Kaup, Chester A
> <kaupca at chevrontexaco.com> wrote:
> > So then, is the Data Entry option enabled?, YES
> > is the table you're adding records to you have a Primary Key ID? NO
> >
> > What confuses me is the form works fine as a regular form but does not
> 
> > work correctly when added to another form as a subform.
> >
> > Thanks for the assistance.
> 
> --
> -Francisco
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 



-- 
-Francisco