Can anyone tell me if the following is possible in a table or do I need to use a form.

I have a check box in a table that when I check it I want it to automatically enter the current date. I also don't want to change the dates that have already been entered manually and that date should only display the date on which the check box was checked. :confused:

It is a database that hold the details of IT equipment and when it is disposed.

I think I may have to use a form but I would like someone to confirm this if it is possible to do in the table could someone also help me implement it.

Thanks in advance

I feel certain that most seasoned developers will strongly recommend that *all* information entered into a table in Access be done through a form. Does that answer your question?

Thanks for your reply RuralGuy.

Thats want I would like to happen, but I will have to get my boss to approve this as I think he was hoping that I could implement it without the use of forms for some reason :rolleyes:

Eventhough it would be the wrong way to set it up is there a way to do it in a table.

There are no table level triggers in Access like there are in SQL. All of the events you will need to validate and implement your tables are only available in forms. I do not know of a way to do what you are asking at the table level. Do you know why your boss is opposed to using forms? They really are the backbone of an Access Application and pretty easy to set up.

You need to upgrade your boss. Boss 5.1 has an irrational fear of forms. Service pack 3 fixes this but you'd be advised to do a full upgrade to Boss 6.0.

You need to upgrade your boss. Boss 5.1 has an irrational fear of forms. Service pack 3 fixes this but you'd be advised to do a full upgrade to Boss 6.0.

Too bad we are so stuck with PCs, with the MAC version you are your own Boss ;)

Put coding in the onclick event of the check box so that if the box is checked [true] and the dispose date is null then dispose date equals todays date.