Combo Box, Subform, Text Box - Relationships/Filter

[wayniac42]

What I am trying to do is select an item from the combo box and have it displayed in the subform. Then once you scroll though the subform and find the field you like, click on it and it will automatically be transferred to a text box.

I have created a 3-step image demonstrating how it should look.

Also I have the information behind the subform linked together as a foreign key in a relationship.

http://www.geocities.com/database4242/database.JPG

Please help me see what I am doing wrong, thank you.

 

[VRoscioli]

What do you currently have set as the sources, etc. for the form, subform, and textbox?


-V

 

[wayniac42]

Are you referring to the record sources?

 

[VRoscioli]

And the control source for the text box.


-V

 

[wayniac42]

Form Record Source: "Contacts" (table)

Subform Record Source: "SELECT [NOC Title 1].NOC, [NOC Title 1].[NOC Title] FROM [NOC Title 1];"

Subform Source Object: "NOC Title 1 subform1"

Form Textbox Control Source: "NOC Title 1"

Subform textbox Control Source: "NOC Title

 

[wayniac42]

Oh shoot...

Form NOC Classifications Control Source: "Work Preference 1"

This is a combo box that looks up the subform.

Sorry for the inconvenience.

 

[wayniac42]

If you require anymore information feel free to ask and thank you for your on going efforts.

 

[AG3VBA1006]

You need to create a query that uses the info in NOC Classifications as a filter. That query should be used as the source for your step 2 table and the query and form need to refresh when you update/change the NOC Classifications in step 1. You can then assign a variable to be equal to the selected data in the step 2 table and that variable as the source for your Output Vale in step 3. I'm sure there is a more elegant way to handle your issue, but I am not a programmer, just a user who programs out of necessity.

Hope that helps.