list not connecting to form

[carbo20]

hello
i made a form with list in it.
i want that every time that i double click a row in the list it will open the
CORRECT record.
i have a problem that when i click on the row it open always the first record
of the form insted the record that belong to the row i wanted to open.
how can i fix it?
thank you.

 

[ColinEssex]

I may be wrong, but doesn't the ListBox wizard offer this as one of the options?

Col

 

[carbo20]

there is agood chance that i am wrong but..

I may be wrong, but doesn't the ListBox wizard offer this as one of the options?

Col

all i saw at the wizard was to choose a table/query and to choose the field from the table to be shown on the list.
but what i want is to click on a row and that the form with the row information will appeaer.
.
now what happens is that the same form (with the info of the first line) appears all the time,no metter what line i click on.

 

[Pat Hartman]

I believe it is the combo wizard that offers that option. If you can't write the code yourself, add a button to the form and choose the find a record option. Then copy the generated code from the button and place it in the double click event of the listbox. Then delete the button. Make sure you understand the generated code and you'll be on your way to learning VBA.

 

[carbo20]

problem

I believe it is the combo wizard that offers that option. If you can't write the code yourself, add a button to the form and choose the find a record option. Then copy the generated code from the button and place it in the double click event of the listbox. Then delete the button. Make sure you understand the generated code and you'll be on your way to learning VBA.

thank you for your answer.
but it doesn't work.
i am new in the access field.
isn't there a site that give examples?

 

[Mile-O]

Examples like this?

 

[Oldsoftboss]

When you use the listbox wizard, if your form is not currently based on a table, the "Find a Record" option is not available. I suspect this may be your problem. Check to ensure the form has a record source and try again,

Dave