Multiple DataSheet view forms based on queries linked??

[williekay]

I have 3 or 4 queries that get blended into one query. I have another set of queries that have the same key fields. This set of queries shows an entire set of different information. What I'm trying to do is have a form with a 'KEYFIELD' box. This box will be linked to one of the tables that contains the common key fields. I will populate this box with a double click event from another form. I want 2 subforms on the form that are linked to the 'KEYFIELD' box. I have the 2 forms, but I'm getting errors in every field.

Willie

 

[ZmrAbdulla]

Look into the Northwind database customer orders form.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Seek counsel of him who makes you weep, and not of him who makes you laugh.