How do I open a form based on a selected record from a list box

[phyllisk]

Hi, I wonder if anyone can help me.
I have created a basic search facility in Access 2000. I enter the surname of the client and the underlying query matches the surname with all clients with the same surname.
The results (ie. Surname, Forename & DOB) are displayed in an unbound list box.
How do I goto a record, located on a different form, of a specific client that is displayed in the list box??

 

[LonnieJohnson]

I am going to assume that you have three columns in your listbox.

ListBoxName.Column(0) = SurName
ListBoxName.Column(1) = ForeName
ListBoxName.Column(2) = DOB

In the listbox's double click event I would put


DoCmd.OpenForm "YourFromName", , , _
"SurName = '" & ListBoxName.Column(0) & "' AND " _
"ForeName = ' & ListBoxName.Column(1) & "' And " _
"ForeName = ' & ListBoxName.Column(2) & "'"

The OpenForm command has positional parameters. The fourth parm is where you can insert criteria for opening the form.

Good luck... B-)
ljprodev@yahoo.com
ProDev, MS Access Applications

http://www.galaxymall.com/software/PRODEV