Hi All,

My new question is:
I am trying to open a new form from my main form, for the same record I am
editing.

My code is:
DoCmd.OpenForm [PICS], acNormal, "", "[MODELNUMBER]=FORMS![PARTSFORM]!
[MODELNUMBER]"

This code works fine if that [MODELNUMBER] already exists in PICS table.
If I have not entered any data for that Model Number in Pics, the form opens
blank, "No [MODELNUMBER], and I have to manually enter it.

I tried If statement to check for [MODELNUMBER] to see if its Null, and fill
the field, but did not work.

Any ideas to put me in the right direction will be appreciated.

Jim