Breaking News: Grepper is joining You.com. Read the official announcement!

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

Green Team answered on February 1, 2022 Popularity 6/10 Helpfulness 6/10

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

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

Comment

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

Popularity 6/10 Helpfulness 6/10 Language vb

Source: stackoverflow.com

Tags: add record vba

Link to this answer
Share Copy Link