If closed then set the form to load information as snapshot

M

Marco Silva

Hi. I have a field /yes/no) that tells if the process is closed or not.

I want that the form property RecordsetType be snapshopt when the process
was closed and Dynaset when is open or set as No.

Regards,
Marco
 
R

Rob Parker

Hi Marco,

I can't answer exactly what you asked. But if what you are wanting to
achieve is to prevent any change to a record where the Closed field is Yes,
you can accomplish this by setting the AllowEdits property of the form to No
when the Closed field is Yes. All you need is code similar to this in the
form's Current event:

Me.AllowEdits = Not(Me!ClosedFieldName)

HTH,

Rob
 
Top