VB6 ADO, MS Access 2000. Dropdown list, select record, this becomes current record
Posted on 2003-12-02
Using VB6, MS Access 2000, ADO. Used VB Data Form Wizard, Access, linked to the database NE.mdb, used "Single Record" option, ADO Data Control, selected a table called "Students", all records in table. I am using an ADO Data Control because I need to update the fields from this form, so I want them to be bound to the database table.
PROBLEM: I have no way of searching for a certain Student, except to click through each record one at a time. I would like to have a dropdown menu on the Name field, be able to select the correct name, then have this record become the current record.
There are many fields so would like to avoid using many lines of code to re-populate each field line by line. I just need it to jump to the record (random access) rather than having to click through each sequentially.
I tried "Creating a Simple Datacombo Application" but it would not allow me to enter a Listfield in the properties of the DataCombo.