• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 346
  • Last Modified:

Save record when user hits processing button ACCESS 2003

I have checkboxes on a form that when checked, the record should be part of the processing.  However, if the user checks the box and then immediately hits the processing button, the record is not recognized as being checked, as though the information has not been saved.  So, if the user checks the box, but does not click on another field or place on the form to save the changes, how can I be sure the checked box is recorded when the user hits the processing button?  This is an ACCESS 2003 form.

Sandra
0
ssmith94015
Asked:
ssmith94015
2 Solutions
 
Rey Obrero (Capricorn1)Commented:
try placing this line at the top of the Click event of the processing button

private sub btn_click()
me.dirty=false
0
 
pdebaetsCommented:
In the Processing Button OnClick event procedure put the following code before any other code:

Docmd.runcommand accmdSaveRecord
0
 
ssmith94015Author Commented:
I don't know why, but actually a combination of both worked.  Thank you.

Sandra
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now