User selects name from lookup field and info displays on another form 1

[Heeeeelp]

Hi,
I would appreciate some help. I've been struggling with this for two days now and I'm sure it should only take minutes but I haven't been able to find an example to solve this problem.

I have a form called "Advisors", which displays an advisors id, first name, last name, and other information pertaining to the advisor. I have created a separate form called, "Select Advisor", which displays the advisors first and last name in a lookup field.

SELECT [Advisors].[AdvsrID], [Advisors].[AdvsrFName] & " " & [Advisors].[AdvsrLName] AS Expr1 FROM Advisors ORDER BY [Advisors].[AdvsrFName] & " " & [Advisors].[AdvsrLName], [Advisors].[AdvsrLName];

How do I set this up so that when the user selects the advisor's name from the lookup field, the advisor's information is displayed in the "Advisors" form. Also, there is a subform on the Advisors form displaying the advisor's cases. How do I synchronize it so that when the Advisors form displays the selected advisor's information, the subform also displyas the corresponding cases. The Advisors form and the cases subform are linked by the AdvsrID.

I would greatly appreciate your help with this.

Regards,
Tess

 

[ZmrAbdulla]

Create a combobox on the main form through the wizard and choose the third option(find a record...) from the wizard.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Education's purpose is to replace an empty mind with an open one.
~Malcolm S. Forbes~

 

[Heeeeelp]

I have created a combo box but there is no third option (i'm using access 2000).

 

[Heeeeelp]

Thank you Zameer, I was trying to set up a separate form and therefor was not seeing the third option. I tried the combo box withing the main form and it's working now. I appreciate your help.
Tess