Show all fields after selecting NAME from drop-down

[BlaineR]

Hi,

I've looked in the FAQs and throughout the existing questions, but finally gave up looking. I hope someone will help even if this type of question has been asked and answered already.

I have two tables: tblPlayer and tblAgent. The tblAgent table is prepopulated with all available agents. I have a form called frmPlayer. I want to add a subform (frmAgent) to frmPlayer to display the player's agent's information.

My problem is that I don't know how to create frmAgent so that a user can simply select an AgentName from a combobox on frmAgent (populated with all the Agent names from tblAgent) and have all the other tblAgent fields for that Agent (e.g. AgentAddress, AgentPhone, AgentType, etc.) appear in the respective text boxes on frmAgent.

Can someone help?

Thanks!

 

[Eupher]

BlaineR,

Assuming frmAgent is bound to tblAgent, just put a combo on the form, and at the first combo wizard prompt, select "Find a record on my form based on the selection I made in my combo". Then just step through the wizard. When you're all done, making a selection in the combo will cause the form to automatically go the desired agent's record.

BTW, I assume you have a relationship set up between tblPlayer and tblAgent?

Ken S.

 

[BlaineR]

Hi Ken,

I will try this when I get home. I suspected that it was something fairly simple, but for some reason I didn't see that prompt when I did the drop down originally. I'll redo it and pay more attention.

I do have a relationship set up, good point though.

Thanks very much for your response!