Form Won't Save

[DBL]

Why won't the form save - it's telling me the command or action Save Record isn't available just now. I've got it on a After Update event of a combo box where it saves the record then it previews a report. If I don't save before opening the report half the data is missing.

If Me.Dirty Then
If MsgBox("Record has not been saved. " & Chr(13) & _
"Do you want to save it?", vbInformation + vbOKCancel) = vbOK Then
DoCmd.RunCommand acCmdSaveRecord
Else
Exit Sub
End If
End If

 

[samy]

Check if the Allow Addition and Allow Edits fileds in the form properties are set to "Yes"

 

[DBL]

Yep, it's set to yes.

 

[seth_belgium]

What is the recordsource for the form?

If it's a query, that might be the reason.

Otherwise, please post your DB so we can take a look.

Greetz,

Seth

 

[DBL]

It's a continuous subform. I made a selection in the combo box, which then sets of the print code, and it saved and printed. I changed the selection in the combo box to a different report so I could print that next and it wouldn't save.

 

[seth_belgium]

Yes, OK, but what is the recordsource? Is it a table? A query? ... Please elaborate.

 

[Rich]

I changed the selection in the combo box to a different report so I could print that next and it wouldn't save.

What do you mean by a different Report ?

 

[DBL]

Sorry I don't mean to be vague. The subform is based on a query. The different report was just selecting a different report from the options available in the combo box

 

[seth_belgium]

Open the query from the database window (data-view). Try editing or adding a record over there.

If it returns the same error, or if editing isn't possible, then the cause of your problems is in fact the query's design and not the form's coding or settings.