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!
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!
