I would suggest creating a separate table that would contain the entity. For example:

1.  Members
2.  Vendors
3.  Whatever you wanted it to be

You would put this ID in your payee table and you could filter using it.

In the sub where you're opening the forms:

If NZ(PayeeTypeID,0) = 0 Then
     DoCmd.OpenForm "VendorF"
Else
     DoCmd.OpenForm "MemberF"
End If

Hope this helps,

-Raymond

If you are storing both Vendors and Members in the Payee Table why not have only one Form with a Combo Box to determine the type of payee.

    DoCmd.OpenForm "PayeeF", , , "PayeeID=" & PayeeID

Kevin, Too much information is needed for members so I have a demographic table for that information as ID Codes. It would make the form too unmanageable for the end user (me) when doing data entry. This way I can have the form with just the information I need for that entity. I will try the code you wrote above. Thanks.

Sandra I tried that but was having difficulty putting them into a single payee combo box in my check ledger. I am already managing 2 different banks, 3 types of accounts (checking, savings, CDs, and petty cash), and a chart of accounts with sub categories (for tax purposes). Lots of data for members and minimal data for vendors. It has definitely be a wild ride putting this together. Trying to move from QuickBooks because of the expense on a Non-Profit. Once I get it done, it will be a template for the other 2 Non-Profits for which I am the Finance Officer/Treasurer.

Kathy That's one of the reasons we need to see your Table structure and your Queries / Forms / Reports in Design View. It really does help us to help you if we can see what you are working with.