Subform update . . .too quick (believe it or not)

[educate889]

I have a form with a subform (each bound to separate tables)

I use a unbound combobox to select the company which then populates the continuous subform with all the complaints of that company (parent/child link).

The problem is when I put a QA_Action# in the field in the subform and then move focus back to the main form, it committs that change and no longer shows the record. WHY? I really need the record in the subform to remain visible until the user can enter some more info on the main form that correlates with the QA_Action#.

Please help. . . my deadline is nearing!!!!!!

 

[hillsy]

When you use 2 tables, as in a 1 to many relationship, you must first create a record on the 1 side, in this case your main form, then creating a record in the subform will create the related record.

Since both the main form and subform have bound record sets and you are using the parent/child link between the two of them, this rule applies otherwise records in the subform will just 'disappear'

;-)