[AccessD] Form event when record changes

Thanks Darrin and Dick.

You 

Too

Duane


Joe Hecht
jmhla at earthlink.net
28g
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK
Sent: Tuesday, March 08, 2005 7:04 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Form event when record changes

Hi Joe
Can't you use the On_Current event  

Eg


Private Sub Form_Current()

If me.newrecord = true then
	Msgbox "It's a brand new 'fresh', untouched record"
Else
	msgbox "I have just loaded another record: " & me.YourPK
End if

End Sub

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht
Sent: Wednesday, 9 March 2005 1:28 PM
To: 'Access Developers discussion and problem solving';
ACCESS-L at PEACH.EASE.LSOFT.COM
Subject: [AccessD] Form event when record changes

I have a form that lists products.

 

I need an event that happens on the form as the user scrolls through the
records on the same form.

 

The view is single form.

 

I need to do something like.

 

When new record is loaded into form

            If me.somecondition is true then

            Me.sfrmSamplesize. visible = true

                        End if

 

Thanks 

            

 

Joe Hecht

jmhla at earthlink.net

28g

 

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

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