Using a function - proper newbie alert !

[reddwarf]

Hi guys,

Im STUCK - been working on a project with access and so far so good. We are designed a mini case management system for my company. We are happy with it to date and we wanted to add the functionality to Track changes made to the system for audit purposes. However - this is where the problem is. I have built the whole thing manily thanks to this fourm and i havent needed to post anything - to date. But i have finally found a problme i am struggling to solve.

Maybe you can help me out ?

I have the code i need to do this and i have set up another table ready for the data. I have added the function code to the forms module but when i tadd the name of the funtion to BeforeUpdate seciton of the field i am changing i get and error stating "cant find macro etc etc"

Am i using the wrong Module to add the code to or am I calling the funtion incorrectly ?

let me know if you need further info.

I hope you guys can help.

cheers

 

[reddwarf]

problem fixed

i hadnt used "=" to call the procedure.

stupid...and took ages to figure out !

I have a new problem now, my function works a treat on access 2003 but not in 2000 - just says undefined ?

oh well....still, its all good fun.

cheers

 

[pbaldy]

The function should probably be in a standard module rather than a form's module, unless that's the only place it will ever be called from. It should be declared as public. Since you haven't posted the function or how you call it, hard to say if you're calling it incorrectly.

 

[pbaldy]

Ah, you posted again while I was typing. Again, hard to say why you'd get an undefined error without seeing the function, but my guess would be you're using a DAO recordset without the DAO reference being checked in Tools/References.