Use custom procedure in Access 2000

[shavon]

Hello:

How do I use a custom procedure in A2K please? I created a procedure and I want when a new record is added to the database that this procedure runs and updates a particular field with a particular default value. I created a public procedure in a module. I am trying to use it from the table design page in access...doesn't work!

Thank you,

 

[dhookom]

You can't attach code to a table as either a default or whatever. You can run code in forms. You code might be in the after update event of a control or the form.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[lespaul]

I want when a new record is added to the database

this would be a trigger in other databases; Access doesn't have triggers....

Leslie

In an open world there's no need for windows and gates

http://www.ubuntu.com

 

[shavon]

Thank you...