×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

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

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

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

(OP)
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

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

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

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

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

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

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

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

2
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:

CODE

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.

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

(OP)
Bingo! Thanks Cherio and Hymn!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close