Determine the values displayed in a Combo Box

[Sol]

How can I use the values of one control (radio button) to determine the values displayed in a ComboBox?

For Example, I have a radio button for Type of Server(NT or Novell. When Novell is selected, I'd like only to display Novell Servers in the combo box?

Thanks.

[This message has been edited by Sol (edited 03-27-2000).]

 

[mikec]

Sol,

Here's a solution:

Put the server possibilities into a table. Add a numeric (integer) field to the table. In this new numeric field, for each server possiblity, enter the corresponding option value that you assigned to the values of the option group. (Go to the form design, select the NT radio button and under the properties, select the Data tab. Use the value that is in the Option Value field, probably a 1 or 2. Assign all of the NT server possibilities in the table this value. Repeat for Novell).

In the properties for the combo box, goto Row Source and click the build button. The table should now have your new number field in it. Bring this field down into the grid. Click on the criteria for this field and enter this:
Forms![FormName]![OptionGroupName]

Go to the properties for the option group and enter this into the After Update event (Event Procedure):
Me.ComboBoxName.requery

That should do it. Your combo box should now filter based on whether you have NT or Novell checked.

Mike