How on earth do you save a record programatically?

[Derek]

Hi All

I have a Contact form with Invoice sub form. In the Invoice subform is
another sub called Item.
The operator can by use of a combobox select a ProductID on the item subform
and the combo's other fields automatically enter description price quantity
etc. So at no time does the operator manualy enter any information. The
operator now clicks the Print invoice comand button on theInvoice subform
which opens the invoice report preview and it is obvious that the item from
the item subform has not been saved or queried or refreshed, even thuogh I
have tried all that. Ive tried Dirty refresh requery and even
DoCmd.RunCommand acCmdSaveRecord
DBEngine.Idle dbRefreshCache
DoEvents

How can it be this hard to save information instantly in a database for
heaven's sake. Help!

 

[Chris O'C via AccessMonster.com]

Did you add a save button on the Item subform and put this in its click event?


Me.Dirty = False

Chris