Form Filter

[catat]

Hello!



I have a transaction table set up with FamilyID, Type, Date, etc...

I have 3 different forms for the three different intake types that can be selected. Basically, what I am trying to have happen is when one of the three forms is opened, the form is filtered by the Type.

The only way that I can think of making this work is by having three different queries (one for each type), and I know that there is an easier, more efficient way to do this. I guess that shows how much I know about Access!

Thanks for your help, as always..

[pbaldy]

You can use this technique:

BaldyWeb wherecondition

[catat]

Thank you for the fast reply.
After posting, I realized that I may not have been as clear.
I did use that link for the first part of my table. The FamilyID is already filtered using the Where Condition. After a family is selected, I would like to open one of the three forms that are based on the three types. The three types are Internal Intake, Child Intake, and Family Intake. I have created three seperate forms for each Type. When I open one of the forms, the FamilyID is filtered, showing ALL records for this particular family. I need the form to be filtered by the Type as well. For example, when I open the Internal Intake form, all records for the selected family are showing (Internal, Child, and Family Intake). I only want to view the Internal Intake entries.
I originally had all 3 in seperate tables (which was alot easier, but a waste of space), but I figured it would be better to have only the one table because they all included the same data, just different types of intakes. I hope this makes sense.
Once again, thanks!

[pbaldy]

You could use that technique with 2 conditions, like:

"FamilyID = " & Whatever & " AND Type = 'InternalIntake'"

Does that type of thing work for you?

[catat]

Perfect! I knew it would be a simple solution, but I am so unfamiliar with writing code. Thank you!!

[pbaldy]

No problem, glad we got it working. You can also get the type from the form the same way you get the family ID, if that works better for you.