ComboBox or other selection method

[LadyRose]

Greetings,<br>I am dealing witha database with a great number of records (5000) and expansive field structure.&nbsp;&nbsp;I need to be able to select a record, in this case a student, then list this students information.&nbsp;&nbsp;I have been working with a combo box, I have also tried a listbox,&nbsp;&nbsp;but I get the same results, it appears the pointer in the file moves forward one record and displays this information.&nbsp;&nbsp;Not the record I have chosen.&nbsp;&nbsp;<br><br>How shall I deal with the selection of my records?<br><br>Thanks, LadyRose

 

[Karl Blessing]

you could break the record into pages, then search for a similiar match. <p>Karl<br><a href=mailto:kb244@kb244.8m.com>kb244@kb244.8m.com</a><br><a href=

http://kb244.8m.com>

</a><br>Experienced in , or have messed with : VC++, Borland C++ Builder, VJ++6(starting),VB-Dos, VB1 thru VB6, Delphi 3 pro, Borland C++ 3(DOS), Borland C++ 4.5, HTML,Visual InterDev 6, ASP(WebProgramming), QBasic(least i didnt start with COBOL)

 

[MikeLacey]

LadyRose,<br><br>Could you give us a bit more info with some code? <p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>Please -- Don't send me email questions without posting them in Tek-Tips as well. Better yet -- Post the question in Tek-Tips and send me a note saying "Have a look at so-and-so in the thingy forum would you?"

 

[Guest_imported]

i would suggest using a listview control.&nbsp;&nbsp;then just add the required fields by letter to cut down memory usage.<br>use listview.listitems.add ,&quot;first_last&quot;,&quot;first_last&quot;<br>

 

[LadyRose]

Folks,<br><br>No Code yet, this is part of the question.&nbsp;&nbsp;In the listbox control (MsAccess), I have the problem.&nbsp;&nbsp;I was wondering if I should be using an OnChange event where I record the index, then some sort of show statement to display the information in the textboxes, or mayme Move to the record.&nbsp;&nbsp;I am confused.&nbsp;&nbsp;I have done this with Fox, but VB just doesn't work the same way.<br><br>In the next suggestion, selecting by letter?&nbsp;&nbsp;Am I going to query then those items that begin with a selected letter?<br>How many records can I put into the &quot;subgroup&quot; and still have this control work?<br><br>Thanks for you suggestions.

 

[rajkr]

here you can use dbcombo or dblist. <br>after selecting any item from the list, you have to prepare a dynamic query.for that purpose you can use ADO reference code.<br>Otherwise, you can prepare a query with data control by writing query in recordsource property like &quot;select * from tablename where fieldname like '&quot; & dblist1.text & &quot;'&quot;. but, here record will be fetched when the form will be loaded using the default value of dblist1.<br>Now to make it dynamic , refresh the data control or adodc control that you have earlier written. for example&nbsp;&nbsp;adodc1.refresh or data1.refresh.<br>after refreshing the data now will be according to the present value of dblist1. <br>

 

[Swanson]

Have you tried the grid (such as Videosoft Flexgrid)?<br>You can make two grids: one to display the student and<br>the second one to display information related to that<br>student.<br>When you select one row from the first grid, the second<br>row will display the related information from the<br>selected row of the first grid.<br>