Save Record on field exit, continue to fill form

[capndave]

When the user opens the form a combobox is used to select and populate the value for the PO_number field in tblTissue. The next tab takes user to TissueID field which after the user populates and exits TissueID field the record is validated and saved and the user continue to complete the rest of the fields in the form

What's wrong with

Private Sub TissueID_Exit(Cancel As Integer)

DoCmd.Save ([acRecord As AcRecordType=acDefault], [CurrentRecord]

End Sub

Thanks

 

[PHV]

You may try this:
DoCmd.RunCommand acCmdSaveRecord

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244