Thread: checkbox
View Single Post
  #2 (permalink)  
Old April 13th, 2005, 06:56 AM
rjweers rjweers is offline
Friend of Wrox
 
Join Date: Nov 2004
Location: Seattle, WA, .
Posts: 248
Thanks: 0
Thanked 1 Time in 1 Post
Default

I believe you will have to set up a form to do the data entry.

You can set up the form to look like you're entering data into the table by displaying it in Datasheet view.

In the form, on the ID field, you will write an Afterupdate procedure that will check to see if the field is null and set the Pass/Fail appropriately. The following code assumes that you will want to set the Pass/Fail to false if someone clears the ID field...

Code:
If isnull(Me.ID) then
  me.PassFail = False
Else
  me.PassFail = True
End If
Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org
Reply With Quote