view by category

[Guest]

Hi,
Please can someone help me.
I am trying to set up a form so that I can view my records by category. I
have tried many different ways with no luck. Do i need to have a main form
with a combo box and then a sub form or is it all one one main form. Any
advise would be much appreciated. Thank You

 

[Guest]

the answer depends on how your underlying table(s) are organized.

if the 'category' is a field in the same table as your other data then you
might simply use a query with all the fields you want and put in the 'sort
by' in the category field.

alternately you could do a parameter query based on category

 

[Guest]

that simple? Ok thanks i will try this.

the answer depends on how your underlying table(s) are organized.

if the 'category' is a field in the same table as your other data then you
might simply use a query with all the fields you want and put in the 'sort
by' in the category field.

alternately you could do a parameter query based on category