Linking a form to a another form using a command button?

[Finedean]

Hi all,
I have a form with a list of contact names. I would like to add a button
next to each contact name to open another form that contains Only details of
the that contact.

Name
Button John Lerch
Button Ali Mohm
Button Barbara Kelly

If I click on button for John another form pops up with only john's info
something like this:

Name Address Phone Email
John Lerch 145 Beverly Hills xxxxxxxxxxxx Joh@XXXXXX

Thanks in advance

 

[PHV]

Why not simply a ListBox with something like this in the DoubleClick event procedure:

DoCmd.OpenForm "your detail form", , , "[Name]='" & Me![listbox name] & "'", , acDialog

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[InkyRich]

To make it tidier you could run a query from the Double Click event in the relevant text box. The query could look at the information in the text box and call up the name and details with the query opening a new form.
InkyRich

A fool and his money are soon parted - so you might as well send it to me!