Form Design

[KabirPatel]

Hi,

I have a table with over 10,000 records. I need to show all the records in this table on a form and also make it easy for end users to find records and assign these records to data in another table.

I am considering using a tree view control with a node for each letter of the alphabet. This would exist on the left hand side of the form. Users would then be able to filter by letter and select a particular record. The right hand side of the form would contain the specific details of the selected record.

Is there any other control I should consider or a better way to design this? Any suggestons / code samples would be much appreciated.

Thanks,
Kabir

 

[missinglinq]

The usual control to use would be a combo box.

Place it on your form.

When the Wizard comes up, choose the 3rd option "Find a record based on the value I pick in my combo box"

In the next screen, select the field you want to search by

Finish out the wizard

When you click on the dropdown of the combobox and start to enter a name, the box will autofill, i.e. if you hit B the first record with a name starting with B will come up. If you hit <Enter> at this point it will go to this record, and you can move thru the B's. Or, if you continue to type in letters, it will update accordingly.

 

[KeithG]

Or you could use a listbox and a text box. Where the user could type text into the textbox to filter the listbox. Pretty much the same idea as above excecpt using different controls