Using ListBox as a record navigator

[nishant]

Hello,

Is it possible to use a listbox as the record navigator? That is, when an item in the ListBox is selected (these items are essentially rows in a table), the current form populates all fields on itself with appropriate information with the newly selected record (it is as if you are manually entering a record number).

I've tried to accomplish this using the FindRecord method, but this doesn't really seem to work very well (Access 2000). I don't get any errors, but I also don't get navigated to the appropriate field!

Thank you,
Nishant

 

[dcx693]

Have the form move to the record selected in List/Combo box

 

[nishantd]

thank you!

 

[nishantd]

Going one level further

Would it then be possible to use a listbox within a subform that only populates itself with the data associated with that subform? For instance, FormA has a listbox from which all rows are populated into this listbox.

How can I populate a ListBox in FormB (subform within FormA), when a row in FormA's ListBox is seleced (related tables)? Would I just need to create a query to do this or can I use the current record set of FormB to peform a requery on the ListBox?

Thank you,
Nishant