/VBA/How to use VBA to add new record in MS Access?

How to use VBA to add new record in MS Access?

Private Sub btnAddRecord_Click() 
Dim tblCustomers As DAO.Recordset 

Set tblCustomers = CurrentDb.OpenRecordset("SELECT * FROM [tblCustomers]") 
tblCustomers.AddNew 
tblCustomers![Customer_ID] = Me.txtCustomerID.Value 
tblCustomers![CustomerName] = Me.txtCustomerName.Value 
tblCustomers![CustomerAddressLine1] = Me.txtCustomerAddressLine1.Value 
tblCustomers![City] = Me.txtCity.Value 
tblCustomers![Zip] = Me.txtZip.Value 
tblCustomers.Update 
tblCustomers.Close 
Set tblCustomers = Nothing 
DoCmd.Close 
End Sub

Source: stackoverflow.com

Similar codes

0 vote396 views1 answer
Regex numeric digits
VBA
0 vote418 views1 answer
Vba foreach 2d array
VBA
0 vote342 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote335 views1 answer
Vb test if reference is null
VBA
0 vote356 views1 answer
Excel vba textbox forecolor disabled
VBA
0 vote368 views1 answer
Vba add spaces
VBA
0 vote353 views1 answer
Not allow form to be resized
VBA
0 vote357 views1 answer
VBA Sort RossetaCode
VBA
0 vote449 views1 answer
Vba vbcrlf chr
VBA
0 vote344 views1 answer
Get current url vb.net
VBA