K
Kurt Heisler
On my continuous subform, I would like to prevent the user from
selecting the same item twice from a combo box (called cboAB). The
subform is based on tblAntibiotics.
I made the row source of the combo box this:
SELECT tblLookupAntibiotics.AB
FROM tblLookupAntibiotics LEFT JOIN tblAntibiotics ON
tblLookupAntibiotics.AB = tblAntibiotics.AB
WHERE (((tblAntibiotics.AB) Is Null))
ORDER BY tblLookupAntibiotics.AB;
And added this to the combo box's After Update event:
Me.cboAB.Requery
But when you select an item and move to the next record in the
continuous form, that item still shows up on the list of available
items. It disappears only when you've closed main form (and subform)
then reopened it.
What am I missing?
selecting the same item twice from a combo box (called cboAB). The
subform is based on tblAntibiotics.
I made the row source of the combo box this:
SELECT tblLookupAntibiotics.AB
FROM tblLookupAntibiotics LEFT JOIN tblAntibiotics ON
tblLookupAntibiotics.AB = tblAntibiotics.AB
WHERE (((tblAntibiotics.AB) Is Null))
ORDER BY tblLookupAntibiotics.AB;
And added this to the combo box's After Update event:
Me.cboAB.Requery
But when you select an item and move to the next record in the
continuous form, that item still shows up on the list of available
items. It disappears only when you've closed main form (and subform)
then reopened it.
What am I missing?