I'm trying to copy the data from my form to my table. I wrote this code. and when I'm activating it an error '3061' pops.
EDITED BY THE_DOC_MAN to insert CODE tags; no other changes
the form:
thx for the help
Code:
[
Private Sub ADD_Click()
CurrentDb.Execute "INSERT INTO MAIN(File_Name, File_Type) VALUES('" & File_Name & "', " & File_Type & ")"
Main2.Form.Requery
End Sub
]
the form:
![צילום מסך 2022-01-27 181437.png צילום מסך 2022-01-27 181437.png](https://accessprogrammers.b-cdn.net/forums/data/attachments/86/86311-aef033f9c66dcba1418fbb6e3c45f37e.jpg)
thx for the help
Last edited by a moderator: