Action Query Not Taking Data From Form

[School Boy Error]

I had this problem last week with this database and someone on here kindly fixed it for me. The Compile Report form is working correct up until the last two comboboxes. The date, name and year group fields are fine but it's the location and behaviour type that are going wrong. The person that fixed it said I had done it right it was just a quirk but I can't see why these aren't working! It's so frustrating as I've only been using Access a week and when I have the criteria right I'd expect it to work, it would appear that's not the case! If anyone has time to glance an eye over it, it would be fantastic. Please, please do tell me what you did though. I don't want to have to keep coming back everytime I try to make a change! Thank you.

[rpeare]

I believe I was one of the people responding but I can't read 2007 databases most of the time, if you convert this to a 2003 format I'll take a look.

[School Boy Error]

Thanks for the offer. One of my friends has looked at it and changed it for an IF formula in the criteria which seems to have fixed the issue.

[School Boy Error]

Still not sure why "[Forms]![frm_Report Builder].[Behaviour Type] or [Forms]![frm_Report Builder].[Behaviour Type] is Null" doesn't work but using an If(IsNull([Forms]![frm_Report Builder].[Behaviour Type]),*,[Forms]![frm_Report Builder].[Behaviour Type]) does but hey ho, it's working and I'm happy. Frustrated as a newbie but happy!

Thanks again for the help.