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!

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

Find Record base on Several Combo Boxes

Status
Not open for further replies.
sahaitu

sahaitu

Programmer
Jun 8, 2005
29
US
Greetings:

I am having some trouble in Access 2003. I have a form (frmTest) linked to three tables (tblIssues, tblSubCategory, tblStates). I have combo boxes representing each table on frmTest and they are parent and child linked to a subform.

I am aiming to allow a user to select a value from each combo box (or one) and have the appropriate records returned in the subform fsubCases which is embedded in a tab (Compendium of Cases).

I have the relationships established, the parent and child fields linked in the forms and am not returning the appropriate records at all.

Please help, any suggestions are appreciated...Sahaitu
 
Status
Not open for further replies.

Similar threads

monkeysee
  • Locked
  • Question
Combo Box - Limit results
Replies
1
Views
455
dhookom
dhookom
breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
914
dhookom
dhookom
visitnag
  • Locked
  • Question
combo box entries problem
Replies
8
Views
441
visitnag
visitnag
JanaLNelson
  • Locked
  • Question
Filter as you type combo box in Access 2
2 3
Replies
54
Views
2K
JanaLNelson
JanaLNelson
dhookom
  • Locked
  • Question
Make second combo box display records dependant on selection from first combo box 1
Replies
2
Views
348
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top