default data on form

P

Pauline Duval

I want each new form to open already containing some of the data from the
previous form. I have seen several ideas but none of them worked for me.
I am using Access 2000
 
M

missinglinq via AccessMonster.com

It would keep everyone here from wasting our time, Pauline, if you could tell
what you've already tried that didn't work for you. There are a number of
schemes that work in this situation.
 
P

Pauline Duval

One idea was to create a macro for the "On Got Focus" property but nothing
happened.
I also tried deting the control's defaultvalue property in teh AfterUpdate
event as
Private sub controlname-Afterupdate()
Me.Controlname.DefaultValue - Chr(34) and Me.controlname * chr(34)
end sub
again nothing happened - I did change the "controlname" to my field "Account
number" (which is a string) but the field still came up eplty when I opened
the next form to fill in.
Any idea where I am going wrong?
 
Top