Linking Subform Error

[Mkuria]

If this question had been answered I do apologize..I read through the
questions and I still cannot resolve my issue. I have 2 tables - dist id
field and customer field. I am trying to create a form with 2 subforms....
in the first form the use selects a district id and district information is
displayed. using the selected district I open form 2 to display customer
information for the given district this form is created from a query. Form 3
I need to display data fields to updated based on customer list from form 2
but I am pulling the fields from customer table. I set the control for form
# to (where district id = from form 2) but It still displays all fields.
Can I set one subform to run of a query and another to run off a table?

 

[Stefan Hoffmann]

hi,

I am trying to create a form with 2 subforms....

What kind of layout?

a)

+-form-------------+
| +-subform1------+|
| | ||
| +---------------+|
| +-subform2------+|
| | ||
| +---------------+|
+------------------+

or

b)

+-form-------------+
| +-subform1------+|
| | +-subform2---+||
| | | |||
| | | |||
| | +------------+||
| +---------------+|
+------------------+


mfG
--> stefan <--

 

[Mkuria]

Thanks Stefan for responding - I am using step B. --
mmk

 

[Stefan Hoffmann]

hi,

Thanks Stefan for responding - I am using step B. --
mmk

Okay, it is still a bit confusing.

I have 2 tables - dist id
field and customer field. I am trying to create a form with 2 subforms....
in the first form the use selects a district id and district information is
displayed.

Two tables are normally representing a master-detail view, which
requeries only one subform. Maybe you can clarify your needs a bit more.


mfG
--> stefan <--