gringope24
Member
- Local time
- Today, 23:34
- Joined
- Apr 1, 2020
- Messages
- 51
Hello folks,
the easiest way to add new record seems to be opening a bound a form with a below code and just enter data.
But this method creates a new record when just even one field will be filled.
I want to create a new record after user will fill the field/fields and with full awareness click OK button.
What is the easy way to do it? I thought about creating an unbound form and sending values from the field to the table using SQL or by AddNew Recordset, is it good approach?
Secondly (for general information), what is faster and more efficient method to add new record:
1) using SQL statement and run with command CurrentDb.Execute strSql ?
2) use Recordset ?
3) define a query in Access and fire it with QueryDef.Execute ?
Thanks for your support in advance.
the easiest way to add new record seems to be opening a bound a form with a below code and just enter data.
Code:
DoCmd.OpenForm FormName:="frmAddNewCustomer", DataMode:=acFormAdd
But this method creates a new record when just even one field will be filled.
I want to create a new record after user will fill the field/fields and with full awareness click OK button.
What is the easy way to do it? I thought about creating an unbound form and sending values from the field to the table using SQL or by AddNew Recordset, is it good approach?
Secondly (for general information), what is faster and more efficient method to add new record:
1) using SQL statement and run with command CurrentDb.Execute strSql ?
2) use Recordset ?
3) define a query in Access and fire it with QueryDef.Execute ?
Thanks for your support in advance.