I have an Order form with an Order Details sub form.
The sub form has 3 fields (cboCategoryID; cboPublicationID & Quantity)
I use the cboCategory drop down field to filter the cboPublication field (so I don't have to see 100 pub's each time). I finally got the filtering to work correctly by adding "[Forms]![frmOrders]![SubForm].[Form]![ cboCategoryID]" to [tblPublications]![CategoryID] criteria.
When I enter my first record (publication) in my subform the cboPublicationID field filters correctly from the cboCategoryID field option I selected. Problem comes when I move down to the next record and pick a new cboCategoryID option, as the cboPublicationID field filter still uses the first filter option. So if I filter for books only on the first record and I filter for videos on the next record, the cboPublicationID field is still filtering on books. If I close and reopen the orders form a few times I can get the new record to filter correctly. Tried using the Me.Recalc option in the cboCategoryID AfterUpdate event but it clears all the cboPublicationID field records, I just need the current record to recalc.
Is there a way to Recalc the CurrentRecord only in my sub form or some other way I can get the cboPublicationID field to pick up the new cboCategoryID filter option?
Thanks big in advance!!!!