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 - Limit results

Status
Not open for further replies.

monkeysee

Programmer
Sep 24, 2002
201
0
0
US
I have a combo box that pulls information from a table. The table (FDAcode) lists over 400 FDA food codes. Codes are set up with the first 2 digits defining which part of the code it refers to. So you may have codes IE: 22-601.13; 31-401.23; 11-101.423
So in this example the 22 & 31 & 11 refer to a certain section of the code. The balance of the code (601.13 et) are violations. Each section may have up to 20+ violations. What I would like the combo box do is when the user types in section 22, only the violations associated with section 22 pull. Now of course, it pulls all codes beginning with 22 through the end which is 59.

This combo box resides on an 'inspection' form which is used to record all violations noted during an onsite inspection. So the inspection could result in multiple violations. Is it possible to limit the combo box to focus just on the one section that is typed when recording each violation.

Greatly appreciate any ideas and help!

Thank you in advance to all the great gurus on this forum!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top