Friends...A small problem
I have a combobox in which I want to add list from a field from a ACCESS databas Table.It works well
My code is here
ACRS.Open "SELECT * FROM Salary1", CN, adOpenStatic, adLockOptimistic
Sfm = ACRS!Month
Do Until ACRS.EOF
CmbSfm.AddItem ACRS!Month
ACRS.MoveNext
Loop
My problem is , I want to populate the field Month ,But the value of Month for every 4 records will be the same.Hence the combobox list will be repeated 4 times by the value of month. I want only the first one of the four records so that the list will not contain any duplicate entry. Sfm is the variable for storing the field Month.