Sub form data not saved within tables

[Dasun]

Hey....

I have a main form with some sub forms in it.

My PK is ID which is autonumber
I have uniqe key called ID_No (which is ma serial nbr for records)

All the saubform have this "Intermediate" called relationship in them. I cud not create it as 'one to many' i dnt know why cuz it did not allow me to do when i ws creating relationships. I hope Intermediate relationship does the same task as One to Many does.
and I have already set the link child and master link fields as ID in every one(Making all tables have one to many relationsships{technically :- "INTERMEDIATE" } with the table which main form is bound)

So once the main form is given the ID-No input, as soon I go out of the text box(after_insert), all other subforms displays that value...... but! when I click the add record button and the subform tables do not have the record(it is not saved within the tables), Only the Record in the main form is only saved.

My problem is why it is displaying the ID_No value in subforms but why it is not saving in subform tables

I forgot to say that I have set Data Entry feature turned off and Allow Edits field is ON

SOmebody help pls.....

 

[darkstar257]

Hey....

I have a main form with some sub forms in it.

My PK is ID which is autonumber
I have uniqe key called ID_No (which is ma serial nbr for records)

All the saubform have this "Intermediate" called relationship in them. I cud not create it as 'one to many' i dnt know why cuz it did not allow me to do when i ws creating relationships. I hope Intermediate relationship does the same task as One to Many does.
and I have already set the link child and master link fields as ID in every one(Making all tables have one to many relationsships{technically :- "INTERMEDIATE" } with the table which main form is bound)

So once the main form is given the ID-No input, as soon I go out of the text box(after_insert), all other subforms displays that value...... but! when I click the add record button and the subform tables do not have the record(it is not saved within the tables), Only the Record in the main form is only saved.

My problem is why it is displaying the ID_No value in subforms but why it is not saving in subform tables

I forgot to say that I have set Data Entry feature turned off and Allow Edits field is ON

SOmebody help pls.....

Edit:

Access should automatically update subform data when you change focus out of a subform. There has been cases where this won't happen for whatever reason.

Perhaps you should write something that saves the subform record using on Dirty or change focus or something.