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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

on form close 1

Status
Not open for further replies.
encodeme

encodeme

Programmer
Joined
Jul 8, 2005
Messages
14
Location
PT
Hi I am new to this.
I would like to know how on the close of a form i can set a field value to no (its a yes/no field) for all of the records in an associated table.
thanks in anticipation.
Encodeme
 
Sort by date Sort by votes
An update query run from code may be the easiest way. However, there are so many ways to close a form, you may wish to consider some other event, such as On Load, perhaps.
 
Upvote 0 Downvote
many thanks Remou that works perfectly
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
1K
Kennelbloke
Kennelbloke
TrekBiker
  • Locked
  • Question Question
Form Data Not Updating
Replies
6
Views
995
dhookom
dhookom
TrekBiker
  • Locked
  • Question Question
Forcing Form Updates
Replies
2
Views
785
TrekBiker
TrekBiker
rdpress
  • Locked
  • Article Article
Determine if Close Button is Used to Close Form
Replies
3
Views
415
Andrzejek
Andrzejek
breezett93
  • Locked
  • Question Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
2K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top