Setting the Active Record from a listbox

[PeterJ]

Hello Group,

I am new to this forum, but I have a question regarding a listbox in a form in MS Access.

I want to display the primary keys of an entire database (~300 items) in a listbox in a form.

I want to be able to have the user select a key from the listbox and have the active record switch to the record with that selected primary key.

I am sure someone has to have done this before.

Any help would be greatly appreciated.

Peter

[OBP]

Use a Combo Box, and when the combo wizard asks what record actions you want, choose "Find a record in the table that matches your choice".
The wizard creates the VBcode for you.