Subforms

[MKuria]

I am creating s form to view data and one to update the data -

Is it possible to create 2 subforms using the same table and how do I link
them? I need one to show fields to populate and one to show cust detail'

You help is appreciated
Thanks

 

[John W. Vinson]

I am creating s form to view data and one to update the data -

Is it possible to create 2 subforms using the same table and how do I link
them? I need one to show fields to populate and one to show cust detail'

You help is appreciated
Thanks

I'm not sure, from a user point of view, that seeing exactly the same data in
two places - and being able to update one and not the other - is particularly
helpful! What's the logic of the two subforms??

But to answer, yes, you can. Just use the same query or table as the
Recordsource of each subform. It would be best to make the "view only" subform
read-only by setting its Allow Edits and Allow Additions properties to No.

 

[MKuria]

Thanks for responding. I have set up one form as a view - gives detail
information. The data entry form allows date updates.

I created the forms - I have master form to show Mkt. I have 2 subforms one
shows cust information and is data entry form. subform 3 is displays cust
detail. master form is linked to Subform 1 by Mkt ID.
Sub form 2 and subform 3 have a common key CustID.
Subform 3 is also linked to master by Mkt ID.
(I would like to link subform 2 to subform 3 by custID which is the common
field in both forms. When I click in cust in subform 2 the detail displays in
subform 3.
I an not clear on how to change the Master child links on subform 2

thanks