how to make subform work? in Access Database Forms  
 |  Edit my Profile  |  Help
 
     
  
 
 
 
jmuirman 1/1/2006 8:00 AM PST
  Question
  I have a form with various claim information. I want to create a subform so
that I can record log notes and have them attach to that particular claim. I
already have one subform that works fine. However, when I try and create a
second subform it doesn't work. For example, I created the subform which
contains [date] and [notes]. I made a few entries which did populate the
tClietnNotes. But after I close the main form and reopen, there are no
entries in the sub form that I can see.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Rick Brandt 1/1/2006 8:15 AM PST
  Answer
  jmuirman wrote:
> I have a form with various claim information. I want to create a
> subform so that I can record log notes and have them attach to that
> particular claim. I already have one subform that works fine.
> However, when I try and create a second subform it doesn't work. For
> example, I created the subform which contains [date] and [notes]. I
> made a few entries which did populate the tClietnNotes. But after I
> close the main form and reopen, there are no entries in the sub form
> that I can see.

The table that the subform is bound to has to include a field that links it to
the record in the parent form. In your case that would be the ClaimID or
similar. Then you make the appropriate entries in the MasterLink and ChildLink
properties of the subform control.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com



 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies