Listbox selection retains into following records.

[CregoryJames]

I have googles this and searched forum after forum, but nothing has solved my problem.

The issue at hand is that when I make a selection in a listbox on record 1, the same item is already selected when I move to record 2.

For example.
For Exemptedby (my listbox) I have 5 officer names: Freeman, Markwardt, Harris, Rendon, Haynes

If I select Markwardt in record 1, and move to record 2, Markwardt is already selected, making it look as though Markwardt was the exemptedby choice in record 2.

I would like the listbox to default to a blank choice with each record I create or move to unless otherwise selected.

For example.
If I select Markwardt in record 1 for Exemptedby, when I move to record 2 I would like Exemptedby to default to a blank choice. If I move to record 3 and need to choose an Exemptedby again, say Rendon, I would like to move back to record 2 and still see the blank selection for Exemptedby.

I have also tried linking the Exemptedby to a radio button [Exempt], where Exemptedby would not be enabled (therefore having no value) unless the [exempt] is checked. I ran into a few problems with this as well.

A solution to either problem would be greatly appreciated. I can give any field and value data as needed to clarify. I can also provide some of the VBA scripts I have used and any screenshots if requested.

Thank you,

Hutchinson, Gregory SPC

[CregoryJames]

This was the code I tried using to enable [Exemptedby] only when [Exempt] was checked

If Me!Exempt.Value = True Then
Me!Exemptedby.Enabled = True
Else
Me!Exemptedby.Enabled = False
End If

[CregoryJames]

Also tried this to set default selection to blank, as suggested by another forum

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.Exemptedby.Value = 0
End Sub

[CregoryJames]

Or if I could use comboboxes and set them to open the list on gotfocus that would work too. I have tried this script for that function

Private Sub exemptedby_GotFocus()
Me.exemptedby.Dropdown
End Sub