Please help with combo box parameters

[brokenwh]

Greetings:

I have a form that has two sets of combo Boxes. One is labeled ExhibitorID and the other is ClassNo.

I need some way of making it so that no ExhibitorID above 500 can enter into a class below 2000.

I am sure there is an easy way, but I can't figure it out.

TIA

 

[dcx693]

The situation you are in requires "cascading" combo boxes. I.e., you have a combo box where the available values depend on the selection made in a previous combo box.

You should search the forum for examples, there are plenty of them. Basically, you need to choose an Exhibitor value first, then the ClassNo combo box must only present valid acceptable values. The ClassNo combo box must have as it's recordsource a query that gets you what you need by referring to the Exhibitor field on the form. Best way to learn this is to check out an example.