Problems with calling a function from a module

[algecan]

Ok i've striped it and ziped it. However its still failing to upload, ive tried many times times, I'll keep trying

 

[dbDamo]

I use the code in this link for my audit trail which records changes in a separate table -
http://articles.techrepublic.com.com/5100-10878_11-6166807.html

Hopefully this is what you're after...

 

[namliam]

did you compact it too?

 

[algecan]

I use the code in this link for my audit trail which records changes in a separate table -
http://articles.techrepublic.com.com/5100-10878_11-6166807.html

Hopefully this is what you're after...

Thats the code i used to edit the original code from ghudson to get it into the table. That bit all works fine before i inserted the function. Now it just errors when it calls the function.

Namliam, thanks just compacted it and now its uploaded fine.

If you change one of the combo boxes on the form,you will get an error, if you try again without closing the form you will get a different error. I think the first error - "Item not found in this collection" has something to do with an OpenRecordSet which i dont have

 

[RainLover]

See Attached.

In future it would be a better practice not to have the Field name the same as the Control name.

If the field name is "FRED" then the Control name should be "txtFRED".

Plus there were some other faults but I will leave it to you to have a look.

 

[algecan]

See Attached.

In future it would be a better practice not to have the Field name the same as the Control name.

If the field name is "FRED" then the Control name should be "txtFRED".

Plus there were some other faults but I will leave it to you to have a look.

Thanks for that, I really appreciate the help.

Thanks for the tip as well on naming controls.