Opening subform based on a certain condition

[t3nchi]

I have 2 combo boxes which I select a 'Year' and an 'Incident'. Based on 'incident', a listbox lists whether it was a 'bad' or 'good' incident.

I only want my subform to pull up the record if the listbox says 'bad'. how do I do that?

 

[MartijnR]

Make a query off which the result depends on 'bad'

Use that query to make a subform on your form

 

[t3nchi]

In a query, how do I set the criteria to check if it's True or False? (my 'Bad' and 'Good' is actually a Y/N checkbox)

I want to open my subform if the checkbox is set to 'True'.

 

[MartijnR]

In the criteria field below the field name type true (no " " )
That works in 2003, but I think it should in older versions too. If that doesn't work, try -1 (0 = false)

You can switch between datasheet and design view when you are trying to get the response you want.