[AccessD] Call query in after update of form or It is 11:00 PM doyou know where my brain is ?

In after update of the second text box, or after insert event of form.

Docmd.setwarnings false
Docmd.openquery "qapndNewDoctoJobsTrainDate"
'Me.refresh (may be needed to refresh the screen if the records on the
screen are affected by the query)
Docmd.setwarnings true

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht
Sent: Wednesday, December 22, 2004 2:24 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Call query in after update of form or It is 11:00 PM
doyou know where my brain is ?


qapndNewDoctoJobsTrainDate

Hows that for naming them?

How do I call it from form after update?  

That's where I want to run it after record is added? Or after second txt
box
is updated?

JOE HECHT
LOS ANGELES CA 
 jmhla at earthlink.net



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com