That "pencil icon" to the left on a data entry form 2

[Ogart]

Greetings:

On a data entry form (one record at a time), there's the default vertical bar to the left. When the form is first opened, it has a |> looking half-arrow at the top. As soon as the user types in any data, the icon shifts to a pencil looking thing with three periods. By experimentation, I've learned that clicking on this writes information to the underlying table. My question is:
How do I trigger that event to happen in code?
-or-
What exactly is that event?

Help? Thanks in advance.

CP

 

[hymn]

If you go into the design view of the Form then the propertise then play around with Record Selectors
now search in help and see what you find

Hope this helps
Hymn

 

[Ogart]

The vertical bar disappears in design view, which is why I'm posting.

 

[hymn]

If you go into the properties of the form and scroll down until you come to Record Selectors and then set it to no it will disappear from view in the form's view.

But still go into help and do a search on Record Selectors

Hope this helps
Hymn

 

[cheerio]

The pencil simply means that the editing changes have not been committed to the table. So, for example, pressing escape can undo the changes.

If you put a button on a form with the wizard enabled and select the wizard option for save record it will generate code behind the button that includes the following line:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

Whether that code actually helps you depends on what event will tell Access that it is time to save the data to the table.

 

[Ogart]

Bingo! Thanks Cherio and Hymn!