Display required data in subform help required please

[TIDMAN]

Hello again,

I have 4 forms based on qry's in Access 97 and then i have a main form that displays them as subforms how can i have all the forms display required data e.g by shop order number ?

I tried a paramter qry but the form will not display in the subform then?

Thanks for any help

 

[Len Boorman]

Basically set the sort order of the data from within the supporting query. If you sort within each by by the shop order then each sub form will shown the data in that sequence.

Len B

 

[TIDMAN]

I am now able to view these forms but i am prompted for a value in the parameter box 4 times is there a way that i can view these 4 forms that are based on Qry's by only having the parameter box pop up once or couls anyone suggest an alternative?

Thanks in advance.

TIDMAN.....

 

[TIDMAN]

Thanks fot the help Pat I am not quite sure when it comes to master/child links i have attached a link to my DB for a better idea, the main form is called frm_COPS_ToDo you can then see the names of the sub forms could anyone see if this can be set up master/child and let me know if the main form can have a combo box bound to tbl_COPS so that all the required records displayed in these subforms will be sorted from a selected user.

Thanks so very much in advance for and help.

http://www.hamilton-pc-services.com/downloads/OnTime.zip


TIDMAN....

 

[TIDMAN]

Anyone Please?

 

[rammudali]

Hello again,

I have 4 forms based on qry's in Access 97 and then i have a main form that displays them as subforms how can i have all the forms display required data e.g by shop order number ?

I tried a paramter qry but the form will not display in the subform then?

Thanks for any help

hi,

link your manin form with all 4 four subforms by your common id like shop order number