Graying out record based on field value

lscheer

Registered User.
Local time
Today, 09:13
Joined
Jan 20, 2000
Messages
185
Is it possible to make a specific record (in a form) grayed out when a field "Active?" is designated as "inactive"? I need to keep the person in the db for tracking purposes, even if they are no longer an active participant.
 
In the OnCurrent event of your form place code like:

Me.AllowEdits = Me.blnActiveRecord

Change Me.blnActiveRecord to point to the flag you are using to indicate the active record.

HTH
SteveA
 

Users who are viewing this thread

Back
Top Bottom