Bill Benson
bensonforums at gmail.com
Fri Aug 1 20:31:54 CDT 2014
I don't follow this thread completely, but in my recent project I have a yes/no field in the database called Inactive, whose default is 0. How I maintain that on the form is that I drag that field onto the form, and make it invisible. I then have an Option Group (Frame) control with two Option Buttons: Control Value optActive 1 optInactive 2 On Current, I populate the controls as: Private Sub Form_Current() If InActive = False Then frStatus = 1 Else frStatus = 2 End If End Sub And when the controls are updated I populate the field as: Private Sub frStatus_AfterUpdate() InActive = IIf(frStatus.Value = 1, False, True) End Sub If this is unrelated to what you are dealing with, I apologize.