View Full Version : Reenable ckbx on new record....


imouthere
02-12-2002, 08:45 AM
Hey guys

Kinda new to Access so please bear with me...

I have a form with check boxes on it. When the user selects the checkbox it autofills other fields and disables the other checkbox options. How do I make the selected checkbox and autofilled fields stay the same on the current record and reenable all the checkboxes and clear the autofilled fields on a new record?

Any help is greatly appreciated!
Thanks

Jack Cowley
02-12-2002, 09:56 AM
In the On Current event:

If Me.NewRecord Then
Reset your fields here
End if

imouthere
02-12-2002, 07:17 PM
Thanks alot Jack! That fixed it. http://www.access-programmers.co.uk/ubb/smile.gif