[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 439
  • 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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