Request help with audit trail code and error 2424

[pmcleod]

Good day everyone - hope all had a good holiday.

I have read all the strings on the Audit Trail code and I am using the modified code that was posed by ghudson on Jun 2002. However I am getting the error "2424 - ...can't find a field, control, or property (F8ing through all my code reveals no errors)." I've looked at the code and the form and I can't see any conflicts.

I'd like to start a string on this issue - can anyone get me started?

What do you need to know to help debug this?

 

[WayneRyan]

pm,

When you get your Error Message and select the Debug
option, what line of code is highlighted? Can you post
that section of code?

Wayne

 

[pmcleod]

It's an error on the Form MSG box on close.

It's an error on the form when I try to close the from the MSG box (MsgBox Err.Number & " - " & Err.Description) reads the error. If I try to debug the code its self there are no errors.

The audit trail field is in part getting populated. It will record the "Changes made on 1/7/2004 1:32:00 PM by Admin;" but not the actual changes.

 

[spacepro]

Perry,

Hope you don't mind me posting this, just so that people can try and help and I am a bit busy at the moment.


Wayne,

I have been helping perry on a couple of issues, have a look at the zip and open the frmLabsSubmittorItem Form, click the check box or add a record and then close the form, it generates the error based on Mdule 1( Audit Trail Code) that I am sure is triggering the error.

Download the zip by clicking the below link.

Download Zip

Keep me posted.

Andy

 

[pmcleod]

The error based on Module 1( Audit Trail Code)

No worries Andrew - I welcome your help and advice.

 

[WayneRyan]

pm,

The field "tblLabsAdditionalTestsItem_ID" is bound to your table
and is no longer in your table. Or it has some other name now.

Wayne

 

[pmcleod]

Doh! Whitehend was right!

Talk about not seeing the forest through the...I looked at that form I don't know how many times and not once did I remember that that bound object was still there and hidden no less.

Thanks a bunch.

It takes a very unusual mind to make an analysis of the obvious - A.N. Whitehend