Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combo Box, Subform, Text Box - Relationships/Filter

Status
Not open for further replies.

wayniac42

Technical User
Aug 7, 2007
18
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.


Please help me see what I am doing wrong, thank you.
 
What do you currently have set as the sources, etc. for the form, subform, and textbox?


-V
 
Are you referring to the record sources?
 
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
 
Oh shoot...

Form NOC Classifications Control Source: "Work Preference 1"

This is a combo box that looks up the subform.

Sorry for the inconvenience.
 
If you require anymore information feel free to ask and thank you for your on going efforts.
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top