Can't save this record at this time ~ WHY ???

[StuartR]

I have a form which is being used for new record entry but any time I try to close it after data has been input, I get a message stating "You can't save this record at this time"



This error comes up whether the form closure is triggered by a "Close" Button on the form, or by trying to close the form from the little "X" at the top of the form window bar.

Interestingly, the form data IS being saved to the table as required even if you state YES on the dialog box "Do you want to close the database object anyway?"

The only slightly different items on the form from some of my other forms are ...

An unbound combobox taking info from records on the same table so that I can capture an ID number for use in the new record.
A hidden field where the captured ID is input by VBA code in the Private Sub Form_AfterUpdate() and one hidden field is assigned the value "Family (Member)" as follows ...

'Capture Family_ID of Lead Member
Me.Family_ID = FamilyLeadCmb.Value
'Set Membership Class as Family Member
Me.Membership_Class = "Family (Member)"

Any clues re why I am getting this dialog box, and how to avoid it would be appreciated.

Cheers

Stuart

[June7]

Not sure the Form AfterUpdate event is appropriate. I've never used it.

Maybe should use combobox AfterUpdate.

[StuartR]

That did it June.

Thanks for your help.

Stuart