Hi,
I have three field that need to be entered into a line in a subform.
The main form is named [Form-Project/Account Master].
The subform is named [Subform-Financial Transactions]
The three fields are related as follows:
Field 1 is named [Transaction_Donor] and uses a combo box of the master file of donors
[List of Funding Source]. One record per donor.
Field 2 is named [Transaction_Proposal] and uses a combo box of Proposals [Data of Funding Proposals]. One donor to many proposals (grants).
Field 3 is named [Transaction_Description] and uses a combo box of the allocations for the proposal [Data of Funding Allocations]. One proposal to many allocations.
1. I want the user to be able to first select a donor from a combo box.
2. Then the user would select a grant from a combo box that is filtered on the Donor they selected.
3. Then the user would select a line item from a combo box that is filtered on the Grant they selected.
I set up the first combo box with a field name of cboDonor and it works fine.
It is in the second Combo box that I have trouble. I define 3 fields: [Grant ID], [Grant Description], and [Donor Description]. For the criteria for the [Donor Description] I have tried:
> [Forms]![Form-Project/Account Master]![Subform-Financial Transactions]![cboDonor]
> [Forms]![Subform-Financial Transactions]![cboDonor]
> and a bunch of other things.
But it always gives me an error "Enter Parameter Value" for whatever I have in the criteria. When I enter the value that I entered in the previous combo box, it displays the correctly filtered list, so I think the problem has to in the coding of the criteria. I'm wondering if there is something special about the subform.
I have put the requery after update in the first combobox.
Sorry for the really long question. I'm hoping it's really a short answer...something stupid I'm just missing.
Merrikay