Make records read only based on specific field value

[spectraflame]

I would like to be able to open records as read only if the STATUS field contains the value of CLOSED. If the field contains the value of OPEN, I would like to be able to modify the record until the status is changed. My hopes are that once the work order is closed, the record will be read only unless the password protected modify button is clicked.

Thanks,
Matthew

 

[lovemuscle2005]

Create 2 forms, one read only and one ADD mode, base them on 2 queries, one with parameter to open and one with parameter to closed.

Jobs a gud-en!

 

[Norie]

Why not create code that checks that field when the record is opened?

It could then lock the record as required.

 

[spectraflame]

Norie,

Your suggestions sounds logical. Would it be the easiest to create an On Open event for that specific form that if the status = CLOSED the ENABLED setting for each box would = FALSE and if the status = OPEN, then open the record as normal?

Matthew

 

[Norie]

Matthew

I'm not sure which event would be best.

It depends on how your form is set up.

On Open might work for a single view form.

But On Current might be a better idea.

Another option could be to have the records read only as default and only allow editing view a command button that checks for a password and the status.

 

[spectraflame]

Is there an easy way to set the entire record to read only?