combo box

[alifyag]

hi,
i have a combo box which is going to contain certian fieldnames.
i want to have only certain fildnames in it and not all. i used the following code

Set rs = CurrentDb.OpenRecordset("Select top 1 * from Publishers;&quot
For i = 0 To rs.Fields.Count - 1
If rs.Fields(i).Name <> &quot;Balance&quot; Or rs.Fields(i).Name <> &quot;PubID&quot; Then
strNames = strNames & rs.Fields(i).Name & &quot;;&quot;
End If
Next i


i didnt want balance and publid in the combo...however this didnt work...
please lemme know
alifya

 

[cmmrfrds]

Try changing the OR to AND. Check your booleans.

If rs.Fields(i).Name <> &quot;Balance&quot; AND rs.Fields(i).Name <> &quot;PubID&quot;