Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changing check.value on form's exit.

Status
Not open for further replies.
MuskyMan

MuskyMan

Technical User
Jul 31, 2002
36
US
Need to change the all records Yes/No field to NO in a table when the user closes the form. The number of records in the table changes daily. Can't seem to get the code correct.

Thanks for the help..

 
Sort by date Sort by votes
You can setup an update query to update that field when the form is closed. Put the code before the form docmd.close line.

That's it.

:)WB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
1K
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Use combo on form's tab page as query criteria
Replies
5
Views
282
TrekBiker
TrekBiker
applestoapples
  • Locked
  • Question
Create duplicate rows based on Qty field
Replies
7
Views
401
Andrzejek
Andrzejek
Lamar Washington
  • Locked
  • Question
Programmatically send email using only OWA
Replies
2
Views
474
Andrzejek
Andrzejek
TinaS
  • Locked
  • Question
Quick one I think - question about Properties window in Form Design view
Replies
1
Views
348
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top