I am currently workin on forms in MS Access. Here's my question:
I have created a form that adds a record to a table. Now I need a button that restores all form fields when clicked. Here's the code I use now:
Private Sub resetform_Click()
DoCmd.Restore
Exit_resetform_Click:
Exit Sub
Err_resetform_Click:
MsgBox Err.Description
Resume Exit_resetform_Click
End Sub
The red code does not what I wanted, it somehow resizes the form window...
Are you inserting the new record when a button is clicked? By default a form will automatically insert and update records when you start typing unless you program the form otherwise. So, if you haven't programmed it to update after the fact then a reset button won't work, unless you store the "old" values in the form somehow.
Yeah, the new record is inserted when a button is clicked, no data is inserted unless the button is clicked. (on data submission via the button click the form resets) Another button ends the form. And the last one should reset the form...
Private Sub eintragen_Click()
On Error GoTo Err_Befehl36_Click
DoCmd.GoToRecord , , acNewRec
Exit_eintragen_Click:
Exit Sub
Err_eintragen_Click:
MsgBox Err.Description
Resume Exit_Befehl36_Click
End Sub
That's the code that inserts the new record. I just thought there was another DoCmd.??? command to achieve this the easy way. I'm lost
While I have solved the problem above (I no longer need that button) I have another question:
Again, I have created a form (no auto-form).+ On clicking the submit button, the values are checked (and or changed). Now how do I insert those values into a table?
you can do some sql stuff in the page code. look up opening recordset in the help section when you are in the vba editor. it should have some examples. it's similar to what you would do on an asp page.
Topic Locked
Posted - 30 July 2003 : 08:41:20
