Filters

[Sean_Sean]

I have got 5 forms all useing the same table but want different parts of information they are divided by 1 field for example: one form takes all the No.1s form the field whereas another takes all the No.2s form it is there any way i can filter it so they only contain the information they are supposed to, Like above.

 

[David R]

Please pick one topic and followup under that one, instead of posting a new one every day about the same problem. If you click on your own 'Profile' button you will see a hyperlink to search for all of your own posts. Several possible solutions have been posted there, please tell us what is NOT working, and what you've tried.

David R

 

[Sean_Sean]

Well as of yet i have not tried anything as i do not know how to do it. Basically i've want the 5 forms all reading different information from the same table, is there a way i can just filter out some of the information for each of the forms?

 

[adz2013]

create a query for each form. A form can have a query as a data source.

 

[Sean_Sean]

What should the queries contain?

 

[adz2013]

Each query should have the fields that you want in your form.