Hello,
I have a table called CodaTable
Where the user inputs the system path to a file and associates it with a Sample Bag No.
Then I have another table and a form for it, TasksDNAAuthentication
Where the CoDA field is a combobox with the row source:
Code:
SELECT [CodaTable].[Coda], [CodaTable].[SampleBagNo] FROM CodaTable WHERE [CodaTable.SampleBagNo] = [Forms]![TasksDNAAuthenticationSubform]![SampleBagNo] ORDER BY [CodaTable].[Coda];
With this row source, when I open the form the combobox will only filter for the first samplebagno selected, and then every subsequent combobox is then filtering by that same value. Ex: Select combobox for A1002, then select combobox for A1000: it still filters for A1002, giving the wrong result.
What should the row source code be that filters this CoDA combobox by SampleBagNo per line instead of assigning the first SampleBagNo to the filter variable?
Thanks.