Query by value in line item field (datasheet)

[pmontalt]

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:

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.

[June7]

Must requery the combobox. Use combobox GotFocus event and code:

Me.comboboxname.Requery

Be aware, conditional combobox will not work nice in continuous or datasheet form if the combobox RowSource has a lookup alias.

[pmontalt]

Thanks June7!