Using a form to insert a record

[sharpnova]

I'm trying to make modifications to an existing Access application.

The app currently has a form in which, when a user presses enter in one of the fields, it inserts all the current fields on the form into a table.

I am trying to figure out why. I've looked in the form's properties, the field's properties, and all the event code for the entire application.

I see no reference to the table in question.

So how is this form and its fields bound to that table in an insert relationship?

 

[pbaldy]

Is the form's Record Source property that table? Or a query on that table?

 

[sharpnova]

Is the form's Record Source property that table? Or a query on that table?

The record source of the form is a SELECT query that selects that data from the table, which is fine.

But I'm trying to figure out why updating the fields then INSERTS the data into the table. There is no INSERT statement anywhere in the code.

 

[pbaldy]

If the form is on a new record, it will insert one. What is the Data Entry property of the form? If it's Yes, or there's code when the form opens to go to a new record, there's your answer.

 

[missinglinq]

The app currently has a form in which, when a user presses enter in one of the fields, it inserts all the current fields on the form into a table.

I'd guess that the 'field' in question is the last Control in the Tab Order. By Default, when you leave the last Control in the Tab Order Access moves to a New Record, which automatically saves the Record to the underlying Table.

To change this Default behavior, in Form Design View, go to Properties - Other and change the Cycle Property from All Records to Current Record.

Linq ;0)>