Hi,

I'm trying to create a database for tracking jobs in our office. It begins with project record that is related to a bid record. I have the idea to keep that bid "open", meaning allow the user to modify fields in it while that bid is out.

Once we receive notificiation of bid approval, I'd like to lock the bid record from modification, since all cost tracking from that point forward will be done within a budget record for that project.

Is there a way to lock a record once a specific action is taken? ie button clicked, field fillled in? I can't seem to find how to do it on my own.

Thanks in advance for any advice and feedback on this.

Antonina,

Take a look at the methods from this post.

Also another method is that you can have two layouts. one for modifiable fields and the other non modifiable.

Depending on the value of your field, you can send them to a different layout. If ModFlag =1 then Go to Layout - NOmodify, else go to layout - modify.

Hi and thank you so much. I think the separate non-modifiable layout is such a simple and easy way to go.

Thanks.