>Excuse my ignorance but is it possible to pass some parameters to an Access form? How do you set the form up to receive them is it in the open or load events?

There are a number of ways:
- Using global variables (not very elegant)
- Using private properties (Property Let & Get, you have to assign values before showing your form)
- Using OpenForm and OpenArgs: (DoCmd OpenForm, "frmB", , , , , CStr(integerValue) and then use OpenArgs to read the values)
HTH