[AccessD] DETECT WHEN FORM IS IN ADD NEW RECORD MODE

Hi Joe
Like David said
Test the Me.NewRecord property

If you are gonna hide and disable certain things on a form - it is best 
You make your form's default view as: single view - IE NOT continuos
Eg like

If me.newrecord = true then
	'hide or make visible
	'or enable/disable whatever you want
Else
	'Not a new record
	'Enable and make visible the normal stuff
End if


You really don't need the "else" unless you can move from record to record
Using nav buttons etc.

HTH
 


Darren
------------------------------
T: 0424 696 433
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht
Sent: Wednesday, 22 February 2006 4:14 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] DETECT WHEN FORM IS IN ADD NEW RECORD MODE

I need to do this.

 

            If form.add new = true then 

                        Cbo1.visible = false

                        Cbo2.visible = true

            Else

                        Cbo1.visible = true

                        Cbo2.visible = false

            End if

 

Thanks

 

 

Joe Hecht

jmhecht at earthlink.net

 

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