problem with default value on a form

[cinders]

I have an unbound form (form A). Depnding what is input on form A another form will open. For this example Form B. Form B has a field called ContNbr that defaults with the value from a field on form A, this field on Form B can be overwritten/changed by the user. Within Form B is a subform. The subform populates with additional details about ContNbr, based on the value in ContNbr on Form B.

If I manually type in my ContNbr the subform populates with the additional details perfectly, but it will not populate (stays blank) if the default value from formA is left in the field and is not overwritten by the user.

Would anyone know why this is???

Thanks

Cindy

 

[cinders]

Okay, I figured out that the record must be saved before the subform can reference this record. The problem is the first 2 fields on the form default from another form, then the subform fields are supposed to populate, so basically there is no physical input by a user (yet) to trigger the record being saved and the subform being able to refernce the value in the preceeding field, so....

long story short, I need to be able to trigger this record to save on the On Enter or On focus event of a field on the main form. Can anyone help me with this?

Thanks

Cindy