View Full Version : Filters


Sean_Sean
02-04-2002, 10:06 AM
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
02-04-2002, 12:58 PM
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
02-05-2002, 10:34 AM
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
02-05-2002, 10:48 AM
create a query for each form. A form can have a query as a data source.

Sean_Sean
02-05-2002, 11:45 AM
What should the queries contain?

adz2013
02-05-2002, 11:46 AM
Each query should have the fields that you want in your form.