• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• SQL Statement, Select all Distinct Record on a Table and populate it on ComboBox or ListBox. Any Ad

SQL Statement, Select all Distinct Record on a Table and populate it on ComboBox or ListBox. Any Ad

SQL Statement, Select all Distinct Record on a Table and populate it on ComboBox or ListBox. Any Additional Code Send it to my E-mail...

Rate SQL Statement, Select all Distinct Record on a Table and populate it on ComboBox or ListBox. Any Ad

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

  Data1.Recordsource = "SELECT DISTINCT <Field> FROM <TableName>" 'Filter Fields with a unique Name
  Data1.Refresh ' Refresh The Table
While Not Data1.Recordset.EOF
   Combo1.AddItem Data1.Recordset("Field") 'Field on SELECT
   Data1.Recordset.MoveNext ' View all Field Content
Wend
End Sub

'Note U  can use (ListBox or ComboBox)
'U can also code it on CLICK Event and KEYPRESS Event