Checkbox Closed...PopUp

[wnicole]

I want to create a simple warning that says "this project is closed are you sure you want to enter data"
When a project is check off as Closed I want to trigger this msgbox when any new information connected to that project number is entered.

I don't know how to do this. DOn't want to necessarily do it from a form angle as info can be enter from different forms.
I was wondering is there a way to do it from table angle. The checkbox for Closed is in the table of the projects. So when they check that off I want to make sure that any new expenses or updates made to that project will trigger this msgbox.

Can you help with any code that can do this?


Thanks

[sdel_nevo]

Hi wnicole

could you do it by a lookup? i do pritty much the same thing, i check to see if someone has market a invoice as closed so if someone tries to open it they get a message telling them as such and they can't alter it

checkbox = DLookup("[checkboxname]", "[tablename]", "[CompanyID]") "alter these to suit"
if checkbox = true then
msgbox "test"
end if

you could put this on the onclick event of the check off process

hope this helps

[wnicole]

I tried this and it works when u want to control just the checkbox however I want to control and new entries to that record that is closed. So if someone try to change any field in a record that is check off closed they get this msg box . Can you assist

[sdel_nevo]

Hi

could you not put the above into the on open event of the form that holds the fields?

Steve

[wnicole]

Sorry typed in wrong thread