Continuous Form - Dynamic Combo Box RowSource

[Jake0254]

Hello



I'm currently creating a new db that enables my team to perform quality assurance, and have come across a bit of a stumbling block that I'm hoping you can help me with. I'm no pro, entirely self-taught, so hoping someone can provide some guidance

I have a Continuous Form that retrieves a list of criteria from a query. I then need the users to be able to assign a score against each of the appropriate criteria, but the type of criteria can differ dependent on that specific criteria. I've created a ComboBox that looks up what the ComboBox values should be from another table, but everytime I try this it seems to have the same result on each 'form' as opposed to each having their own unique one based on the MeasurementType for that criteria.

E.g.

Form has fields:
- CriteriaName (Related to Criteria Table, Criteria Name field)
- Score (ComboBox whose value I want to be dynamic - looks up the MeasurementType for the specific CriteriaName, and returns the list of matching values from the MeasurementTypeValues table)

Table: Criteria

CriteriaName	MeasurementType
Did they do x y and z	Yes/No/NA
Was a b and c correct	Pass/Fail/NA

Table: MeasurementTypeValues

Yes/No/NA	Yes
Yes/No/NA	No
Yes/No/NA	N/A
Pass/Fail/NA	Pass
Pass/Fail/NA	Fail
Pass/Fail/NA	N/A

The results I expect are:

CriteriaName	MeasurementType	Score
Did they do x y and z	Yes/No/NA	ComboBox: Yes;No;N/A
Was a b and c correct	Pass/Fail/NA	ComboBox:Pass;Fail;N/A

The results I get are either both have the Score field as Yes;No;N/A or both have Pass;Fail;N/A

Not sure where to proceed with this - does anyone have any bright ideas please?

Thanks, Jake.

[ranman256]

the combo for 'Did they do x y and z' field should be set to query: qsYN

the combo for 'Was a b and c correct' field should be set to query: qsPasFail

qsYN sql =
select [value] from MeasurementTypeValues where [MType]='Yes/No/NA'

qsPasFail sql=

select [value] from MeasurementTypeValues where [MType]='Pass/Fail/NA'

[Jake0254]

Thanks Ranman, I may not be quite understanding your suggestion, but the issue I have is this is a continuous form, as opposed to separate records in a form, each 'form' is a different criteria. If i'm being silly please do let me know!

I have the Row Source set to SELECT MeasurementTypeValues.MeasurementTypeValue FROM MeasurementTypeValues WHERE (((MeasurementTypeValues.MeasurementType)=[Measurement]));

[dashiellx]

Also, please remember that there is actually only one ComboBox control on a continuous form, so if you change the row source for one, it will change the rowsource for all other records on the form-this won't affect the data, but if the record's value isn't in the new rowsource, it will show as blank.

You might want to check out this Continuous Form Combo demo.

[Jake0254]

Hmm.. Sounds like this might not be possible then which leaves me even more stumped. Thanks for the replies. Back to the drawing board!

[dashiellx]

Hmm.. Sounds like this might not be possible then which leaves me even more stumped. Thanks for the replies. Back to the drawing board!

What you want to do is totally possible, it just takes a bit of work.

[isladogs]

I'm not totally clear what your purpose is and I may be missing the point.
It is definitely possible to have multiple combo box filters on the same recordset in a continuous form or datasheet.
For example have a look at the two examples in this link on my website http://www.mendipdatasystems.co.uk/m...ter/4594454290