Initialising a subform unbound combo

[aine_canby]

Hi,

I have a form with two unbound combos on it. I also have a subform
associated with a particular query which retrieves date for a number
of Tests. I have linked the unbound combos with two of the field in
the subform. So, I can now filter my Tests by Tester and Day Tested.

I'd now like to be able to include an unbound combo on the Subform
which will allow me to jump easily between test results based on the
unique Test Name, rather than navigating using the arrow bottons on
the sub form's footer. So lets say for tester Ian on day Tuesday, I
have 3 tests called Test 123, Test 322, and Test 999, how would I go
about limiting the Subform combo to only include these 3 tests?

Thanks,

Aine.

 

[OldPro]

Hi,

I have a form with two unbound combos on it. I also have a subform
associated with a particular query which retrieves date for a number
of Tests. I have linked the unbound combos with two of the field in
the subform. So, I can now filter my Tests by Tester and Day Tested.

I'd now like to be able to include an unbound combo on the Subform
which will allow me to jump easily between test results based on the
unique Test Name, rather than navigating using the arrow bottons on
the sub form's footer. So lets say for tester Ian on day Tuesday, I
have 3 tests called Test 123, Test 322, and Test 999, how would I go
about limiting the Subform combo to only include these 3 tests?

Thanks,

Aine.

If you set the combobox RowSourceType property to "Value list", then
you can explicitly add a comma delimited list of possible choices to
the RowSource.