Can't select anything from list box

[laavista]

I’m using Access 2003. I have a list box (called ListRecruiters) in the
detail section of the form. The list box displays the correct values, but
it does not allow anything to be selected.

Row source is: SELECT DISTINCT t_MilitaryBase.Recruiter FROM
t_MilitaryBase UNION select "All" from t_MilitaryBase;

Row Source Type: Table/Query
Bound Column 1
Allow value list edits No (I’ve tried yes)
Inherit value list no
Show only row source value no
Enabled yes
Locked no

The values in the list box are correct so I’m assuming the row source is OK.
When a command button is clicked, I call a procedure. Part of it follows:

Dim strIN As String


Set MyDB = CurrentDb()

strSQL = "SELECT * FROM t_MilitaryBase"

'Build the IN string by looping through the listbox
For i = 0 To ListRecruiters.ListCount - 1
If ListRecruiters.Selected(i) Then
If ListRecruiters.Column(0, i) = "All" Then
flgSelectAll = True
End If
strIN = strIN & "'" & ListRecruiters.Column(0, i) & "',"
End If
Next i

Your help would be greatly appreciated!

 

[Stefan Hoffmann]

hi,

I’m using Access 2003. I have a list box (called ListRecruiters) in the
detail section of the form. The list box displays the correct values, but
it does not allow anything to be selected.

So you can't select any value in your ListBox? Or does the CommandButton
not work properly?


mfG
--> stefan <--

 

[laavista]

The command button works.

The list box is populated and the values are not greyed out. I just cannot
select any of them.

Thanks, in advance, for any help you can provide.

 

[Stefan Hoffmann]

hi,

The list box is populated and the values are not greyed out. I just cannot
select any of them.

Sounds weird. Create a new form, place a ListBox on it and assign the
RowSource. Does it work? If so, check whether you have set AllowEdit of
your form to true.


mfG
--> stefan <--

 

[laavista]

You were right. The allow edits on the form was set to no.
Thanks so much!!