View Single Post
  #7 (permalink)  
Old February 19th, 2004, 12:19 PM
SerranoG SerranoG is offline
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
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

Move the entire code from the ON OPEN event to the ON CURRENT event. This will activate it everytime you move from record to record. However, if you DON'T want it happen for previously entered records and you ONLY want it to happen to NEW records, you need to surround the whole thing with
Code:
   If Me.NewRecord
      ...
   End If


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote