I have a main form, " frmFundingDistribution ", with a combo box "cboProjectRef";
and a sub form "subfrmEventPayments " that has a combo box "cboEventDescID".
I need the combo box on the subform to filter based upon combo box on the main form.
Now I've tried putting this in as the row source for the subform's combobox:
SELECT [tblEventDescription].[Event Name], [tblEventDescription].[Event Number], [tblEventDescription].[Event Desc ID], [tblEventDescription].[ProjectReference] FROM tblEventDescription WHERE ((([tblEventDescription].[ProjectReference])=[Forms]![frmFundingDistribution]![cboProjectRef]));
Now this should work fine and it may appear to work for the first record. However, Access is stupid and will not automatically check to see if the "cboProjectRef" field on the main form has changed or if I have moved to a new record.
I know this won't be much help but I have seen how this is done on this forum, unfortunately I can't remember the answer and the search function isn't working.
Hopefully someone will come along with the answer or the search will work