Automatically create a new record when pressing button

[behedwin]

Hello

Id like to create a button that automatically create a new row in a table, table is named ITLog_Table
The table contain the following columns.
ITLog_ID = primary key for the table
ITLogDatum = date field
Reason = picklist of 4 alternatives
ITComment = text field
IT_ID_SK = secondary key, relationship from IT_ID from a table called IT_Table


When i press the button i want following to happen
1. Create new row in table ITLog_Table so that ITLog_ID gets a new number.
2. ITLogDatum should be filled out with todays date
3. Reason should be filled out with the word "Inventerad"
4. ITComment should be left blank
5. IT_ID_SK should take the value from a textfield in the form where the button is located. Textfield is named txtIT_ID


Anyone able to help me with the code for this button?


I am using access 2016.

 

[stumac]

Maybe something like

Private Sub MyButton_Click()
Dim rs As Recordset
Set rs = CurrentDb.OpenRecordset("ITLog_Table")
rs.AddNew
rs!ITLogDatum = Date
rs!Reason = "Inventerad"
rs!IT_ID_SK = Me.TxtIT_ID
rs.Update
rs.Close
Set rs = Nothing
End Sub

 

[behedwin]

Thank you, that worked great!