• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 307
  • Last Modified:

Audit on Access database suform

Need to track changes in subform.
I managed to track on the main form (with help of EE experts for sure).

Now I need the same on subform,
Attached a sample form database
Att-System-3.accdb
0
MAS EE MVE
Asked:
MAS EE MVE
  • 3
  • 3
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Just transfer the same code for the mainform over to the subform. It should work the same.
0
 
hnasrCommented:
Here You are. Changed few lines in code. Check Module basAudit and BeforeUpdate event of form and SubForm.
Good Luck!
Att-System-3-2.accdb
0
 
MAS EE MVETechnical Department HeadAuthor Commented:
I am getting this error when I paste the codes in my access file
typemismatch.png
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
MAS EE MVETechnical Department HeadAuthor Commented:
Awaiting your reply
0
 
hnasrCommented:
MAS,
It is working as per my understanding.

Please tell me what you did to get the error message.
Explain step by step:
1. Open form (show which form to open)
2. Click in (show which field to click in)
3. type . (show what text to tuype)
and so on

If it stops at a line of code, take a snapshot image.
0
 
MAS EE MVETechnical Department HeadAuthor Commented:
Many thanks I was missing the first line in the audit module.
Now it is working fine. Thanks a lot
0
 
hnasrCommented:
Welcome!
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now