Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 7th, 2007, 12:51 PM
Registered User
 
Join Date: Jan 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Want to perform a task after a form opens/displays

Task: When form opens need to check for records in file A that are not in file B, append new ones to file B. Then count for certain criteria and display the count on the form.

The coding works, but! ...

Placed the code into the Form_Open event and discovered the task executes before the form is displayed.

In what event (or technique) can I place the code so that the form displays and then the task executes?


Ed A
"Smile. Life's going to happen anyway."
 
Old June 8th, 2007, 08:18 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Welcome to P2P, Ed. Pardon my ignorance, but why would it matter when it happens? Don't you want the update to happen regardless? So I would imagine happening before the form displays is desirable.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division





Similar Threads
Thread Thread Starter Forum Replies Last Post
Display Form, then perform operation? SandersM Access VBA 5 June 29th, 2007 08:50 AM
form that opens reports and closes form hartliec Access 1 December 13th, 2006 09:00 AM
FORM action opens in new window nancy HTML Code Clinic 2 April 7th, 2006 08:16 AM
form opens another form tmc Access 3 August 4th, 2004 02:42 PM
Online Task Request Form pill Classic ASP Professional 0 February 4th, 2004 05:17 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.