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

Access Form Capture

Hello All,

Every time I add a new record to a table via a form, what event i can use the capture filed1 of that newly added row into a variable?

Thank you
0
Rayne
Asked:
Rayne
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
The form's BeforeUpdate event occurs when a record is added or updated, so you could do this:

If Me.NewRecord Then
  MyVariable = Me!Field1
End If
0
 
RayneAuthor Commented:
This works :)
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.

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