How to use ComboBox as lookup box for a basic data entry form.
That is, binding a ComboBox to database lookup table using ADO control.
I have 2 ADO controls on the form:
1. ComboBox to specify field in the Table Products.
2. SearchBox for searching/filtering through the Recordset based on ComboBox.
I have Items.mdb with Table Products which fields are Part No and Serial No. And I want to bind ComboBox to specify field in the Table Products.