If closed then set the form to load information as snapshot

  • Thread starter Thread starter Marco Silva
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to define the recodsettype property when loading the form 1
Opening form unexpectedly closes other form 0
How can I edit data on a form w/query w/ one-to-many relationship? 2
blank form, can't insert new record 11
If then Else is not workint to set a field as bold 9
Why are my fields protected? 12
Data In Form Cannot Be Edited 2
Form Not Closing 1

Back
Top