G
Gcook888
The subform records disappear because of condition of recordset.
The subform rec set is SELECT * FROM SubTable WHERE Field1 = [MainFormCtl1] AND
Field2 = [MainFormCtl2] AND Field3 = [MainFormCtl3].
Field1, Field2,Field3 make a primary key in MainTable and used as foriegn key
into SubTable. So when an edit is made the subform records disappear until a
MainForm_AfterUpdate happens apparently. (They come back if i just click in
the subform.)
What can I run in the MainFormCtl AfterUpdate to make the records stay visible?
Or else run something else somewher else?
The subform rec set is SELECT * FROM SubTable WHERE Field1 = [MainFormCtl1] AND
Field2 = [MainFormCtl2] AND Field3 = [MainFormCtl3].
Field1, Field2,Field3 make a primary key in MainTable and used as foriegn key
into SubTable. So when an edit is made the subform records disappear until a
MainForm_AfterUpdate happens apparently. (They come back if i just click in
the subform.)
What can I run in the MainFormCtl AfterUpdate to make the records stay visible?
Or else run something else somewher else?