Thanks for your help,

It gets the value from the main form at the time the form is open. All the values show to be there but at the time of insert something is causing the value to go to NULL and I can't figure out what is causing that.
Bill