Help... records dissapear from continuous forms

[edo]

Hi... I'm using Access2007. I have an OrderDetails form which is a continuous form and is a subform of Orders (with the OrderID as the linked child/parent field).



I can enter the first OrderDetail entry and the form automagically provides a second row to enter a new record.

When I try to enter any of the fields in the second row, the 1st row dissapears and the OrderID is not automatically set (as it was on the first... based on the linked fields).

Why? What's going on? Why is the first row dissapearing???

Hint: If I comment out "Me.Recalc" from the form_AfterInsert event, EVERYTHING WORK FINE... the rows do not dissapear and the OrderID is pre-populated.

I have the me.recalc because one of the controls is a combobox with a _notInList event which apparently required the recalc to keep everything in sync.

Help??

Thanks

-Ed

[RuralGuy]

You should not need the Recalc. Is it a ComboBox on the SubForm that was giving you a problem? Was it from a "LookUp Field"? http://www.mvps.org/access/lookupfields.htm

[edo]

Actually... I just realized that the reason I put the recalc is because I had a "total" textbox (unbound) at the bottom which uses the DLookup function.

I've been trying different approaches... I decided to comment out the refresh and put the total in the parent form (Orders) but that total does not get updated. Just for debug purposes, I created a Refresh button (macro) and that DOES update the total but erases the original entries in the OrderDetails subform.

CATCH-22

[RuralGuy]

Is your Totaling control in the Footer of the SubForm? Why does it use a DLookUP() function? I would think everything you need is on the SubForm.