Hello, I also have this same issue, however I need the changes recored in a
seperate audit table. the code you referenced above inserts the data into a
memo field. how would you go about adding the records into a seperate table.

"Eric Butts [MSFT]" wrote:

Hi,

Put a break point on the line
Set MyForm = Screen.ActiveForm

and step through the code until you get to the error.

- To add a break point right click on the above line and select Toggle
Breakpoint
- Run the code
- Once you get to the breakpoint press F8 until you get to the error

Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
http://www.microsoft.com/security/security_bulletins/ms03-026.asp and/or
to visit Windows Update at http://windowsupdate.microsoft.com/ to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights




--------------------
| Thread-Topic: Keeping Track of Revisions
| thread-index: AcSfw5PmUQeyxfzLQSiESgRQCOoS9A==
| X-WBNR-Posting-Host: 192.169.41.40
| From: "=?Utf-8?B?Q0s=?="
| References:



| Subject: Keeping Track of Revisions
| Date: Tue, 21 Sep 2004 03:13:02 -0700
| Lines: 7
| Message-ID:
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.tablesdbdesign
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.tablesdbdesign:84133
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| Thanks Eric,
| I think you are pretty close with your observation. Only problem is: how
do
| I know which controls have the .ControlType property and which ones do
not
| have?
| ck
|
|
|