Searching data in the current form (Access 97) 2

[HacH]

Hi,

I have created a a form and would like to insert a search facility that allows the user to select from a list the name/id of a person from within the form. This should then update the form fields with the selected record. I tried to use a list box but when I select a name from this list it will not update the form.

Does anyone know what i'm doing wrong? or am I just going the wrong way about doing it? Please help!

Thanks very much in advance.

 

[Crowley16]

you need to update the forms recordsource in the onClick event of your list box

--------------------
Procrastinate Now!

 

[lupins46]

If you add a combo box to the form using the wizard you will be able to do this.
The first question in the wizard asks you what you want to do and you can say 'find a record in my form'.