Access 2010 Listbox search

[Bsamms]

I am very new to Access... I am in the process of attempting a database to hold my passwords. I have prepared a table and corresponding form with on the lefthand side a listbox to contain an alphabetical list of the entries. I would wish to click on the subject in the listbox to display full details within the form. My problem is how do I make the connection.



Any help would be appreciated in the simplest of terms. If any code is required could this be illustrated?

A screen shot is attached.

[pbaldy]

Your simplest solution would probably be to use the combo or listbox wizard and choose the third option, "Find a record...".

[Bsamms]

Paul,

Many thanks for your response.

I am using Access 2010 and having created a ListBox using the wizard I cannot see that there is an option of "Find a record...." Could I ask you to clarify?

Thanks
Brian Samms

[pbaldy]

The form needs to be bound to a table to see the third option; is it? If not, this is the type of code it creates (though in 2010 it would create an embedded macro):

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[FieldName] = " & Me.ControlName
Me.Bookmark = rs.Bookmark

[Bsamms]

Thanks again Paul,

I am reasonably certain that the Form is bound to the only available Table.

Whilst my very limited knowledge extends to creating tables and associated forms it goes no further.

I remain at a complete loss how to show data in Form view from a field name contained in a ListBox.

Can you give me a step by step guidance or point me to a tutorial to illustrate in very simple terms?

Thanks again for ongoing interest.

Brian Samms

[pbaldy]

Can you post the db?

[Bsamms]

Paul

Herewith


Regards
Brian Samms

[pbaldy]

The form is bound to a query, not the table directly.

[Bsamms]

Paul

Bound form to table but makes no difference.

Me thinks will have to abandon concept and manually search with preconfigered "find button".

Thanks for your interest.

Regards
Brian Samms

[pbaldy]

Really? I switched it to be bound to the table, then ran the listbox wizard and the third option showed up as expected. I'm just on a iPad right now, but later I'll be on a pc and will get you the exact code.