Combo Box Filtered based on Control Value

[MSAccessOldTimer]

I have a control form [type] on a form B. The value is tied to a selection made on Form A. Works great. I have a combo box [Requirement] on Form B that contains multiple selections. Not all of the selections are valid for each [Type]. There are three different "types" possible. Within the table (query) feeding the combox box, I added a field entitiled "code"

tblCombo Box
ID
Requirement (text field)
Code (number field) Codes numbers 1, 2 or 3 are assigned to each "Requirement"

On Form B, if the [type] is 1, then I want the combo box to only display the choice for 1. If [type] = 2, then only display the "requirement" choices with a code of 2, and same for 3.

I cannot figured out how to code the "onOpen", or "OnLoad" field in the combo box, or in the properites for Form B, to set the combo box query, based on the value in [Type} box. It keeps showing all requirement choices.



Thank you.

[pbaldy]

See if this helps:

http://www.baldyweb.com/CascadingCombo.htm

[ItsMe]

Sounds like you are trying to set up something that is referred to Cascading Dependent Combo Boxes. I use the AfterUpdate Event of the parent combo to assign a RowSource to the dependent combo(s).

[MSAccessOldTimer]

pbaldy & ItsMe,Thanks. Unfortunately the [Type] field is a not a combo box field on Form B. It is used to display the selection from Form A, which is a combo box. It is a "locked" field, and the data is displayed in a regular field. I am familiar with the cascading combo box programming, but since the data displayed on the upper portion of Form B is a subset of data from the same table used by Form A, a combo box field will not work. I do not want the user to be able to change the [type] on Form B....that would create some bigger issues.

[pbaldy]

The same methods should work, but perhaps in the load event since the value can't change. Actually, using the method with a form criteria should work without code.

[MSAccessOldTimer]

I will give that a try and let you know. Probably tomorrow before I get to that point now....off to meetings. Thanks so much.

[pbaldy]

No problem.