Originally Posted by viv345 View Post
I want know one more thing that if their are more forms in a project viz., Form 1, Form2 etc etc then what will be the coding.
In this project on this command it is giving error
Run-time error '3704'
Operation is not allowed when the object is closed

Private Sub Command8_Click() 'save button
rec.Fields(1) = Text1.Text
rec.Fields(2) = Text2.Text
rec.Fields(3) = Text3.Text
rec.Fields(4) = Text12.Text
rec.Fields(5) = Text13.Text
MsgBox "record stored"
currentRecord = currentRecord + 1
Label3.Caption = "Record " + CStr(currentRecord) + " of " + CStr(rec.RecordCount)

End Sub
from the code above i assume that you run your code with the changes i did,
not my project.

check your code again,somewhere in your code you must have left something like
rec.close remove it and it should be ok.

viv345 like this