Cascading Combo - Minor Error

[fraser_lindsay]

I have managed to set up a cascading combo box by following this guide:
http://support.microsoft.com/default.aspx?scid=kb;en-us;209576

I have two boxes - [BusinessUnit] and [Location]. When I load the form or select one of the [BusinessUnit] I get a box which prompts me to enter a paramter value - [BusinessUnitID]. If I just ok it without entering anything I get to the form and my location select box has the correct locations listed.

What have I done wrong and how do I get rid of this prompt?

Thanks

 

[neileg]

This dialog box appears any time Access doesn't recognise a field name. Have you got a field called BusinessUnitID in your table?

 

[fraser_lindsay]

Found it thanks. There was an error in my naming buried in my IIF criteria in my query. I'll remember to check these in more detail next time.

Thanks