You can do this with a userform - you would need to write the code.

Also look at data = Form . . .

--
Regards,
Tom Ogilvy

sd wrote in message
...
I have a field like Name of Company, name of Party, add1,
add2, add3, City, Pin, Off.Tel1, Off.Tel2, Fax, Res.Tel1,
Mobile, E-mail.

Is there any way can I type name of party it should
display all information of that party. & It is possible
that if I press say Example "A" it should display a list
of all party starting with "A" and I can select the party
and should display in Massage windows party name, Company
name, address telephone no., with ok button.
****al
...