Hi Frnds,

              I want to perform such an operation where after selecting the check box one message box will appear and after deselecting the check box another message box will appear. Please tell me how to do this(with sample code) as I am in new in MS ACCESS programming.

Prasanta,

Use the AfterUpdate event and then evaluate the checkbox.

1. So, make a form and place a check box on the form.
2. Call the checkbox chk1 for the moment.
3. Now bring up the properties for the checkbox and select the Event tab.
4. Find the AfterUpdate event and click the elipsis (...) button at the end of the row, select "Code Builder" when prompted.
5. You should now be in code, with a sub routine called "chk1_AfterUpdate".
6. Now you need to evaluate chk1... given that it is a checkbox, it will be true or false... so, code:

Private sub chk1_AfterUpdate()
if me.chk1 then
'whatever actions you want to do when it is checked
else
'whatever actions you want to do when it is not checked
end if
end sub

Should give you enough to get going with it.

Lee