Limit form to each dropdown option appearing once, enable check box if other check box is true

[Heathey94]

Yes, it has it's own behaviour ID and, the Risk ID is directly linked to whether the behaviour is low, medium or high, therefore has a different Risk ID.



If all of the risks were on one form, there would be up to 57 (possibly more if future versions of the form add more), which would make it harder for the user to find the one they are looking for. Also, the original form which is completed by the assessors (attached) breaks the behaviours down into at risk (low), medium and high risk. I felt that having the Access forms displayed in a similar way would allow the user to input the data on the forms, into the database easily (assessors are not the same as users).

[aytee111]

Yes, you are on the right track.

Back to your original issue! Having a filter on the form using a query as the record source that filters only the correct RiskID.

[Heathey94]

That's what I thought - which is why I mentioned the Append query - if it's a select Query, you can't then add new rows... right?

[aytee111]

This is the record source for the subform - replace the current one, "TblAssessmentDetails", with a query. And yes you will still be able to add new records.

[Heathey94]

OK, so - to confirm - it should be a Select query?

[aytee111]

Yes. It sounds like you are not getting what I mean - this is to display only those records from TblAssessmentDetails that match the risk level you are trying to display.

[Heathey94]

Oh, I see where the confusion is - as this is the AddLowRiskAssessment form, there aren't any in the TblAssessmentDetails which match the criteria, so I thought this wouldn't work. I'm sure someone once told me you couldn't add rows using a select query, and since there aren't any rows that match the criteria, it didn't make sense for the select query to work.

I'll give it a try tomorrow.

[Heathey94]

I think I've done as you suggested, but nothing changed? It is still pulling the information through from the previous form.

I've probably just missed something in the process.

[aytee111]

I can't see where you have made the change. All three subforms still have TblAssessmentDetails as their record source.

[Heathey94]

I'd changed it on the Forms, not the subforms. sorry, amateur mistake.

That's now all working, thanks

I'm sure I'll have another problem very soon, but for now, that's all I've got, thanks for all your help

[aytee111]

Great - live and learn. Mark this as solved then, and I wait in trepidation!

[Heathey94]

Will do, your assistance has been much appreciated!