|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
November 17th, 2004, 05:03 PM
|
|||
|
|||
How to set a default value for a field in a form
Hi,
I have two amount fields in a form, If i type in one, i want it to reflect in the other amt field, with the ability to edit the second one, with out effecting the first amt field. Any suggestions please. Thank you Rishy
|
|
#2
November 17th, 2004, 05:21 PM
|
|||
|
|||
|
Use the onchange event or similar on the first field. Then attach code like this to the onchange event:
Me.text2 = me.text1.text smartbs www.accessneeds.com
|
|
#3
November 17th, 2004, 09:30 PM
|
|||
|
|||
|
Thank you....but
I tried using the onchange event.. i typed Me.Text0 = me.text2.text, it gives me run time error 2185. It gives a message, you cannot reference a property or a method for a control unless the contrl has a focus.
Please Advise. Thank you Rishy Quote:
|
|
#4
November 18th, 2004, 01:37 PM
|
|||
|
|||
|
Rishy,
Use this Text2.Value = Text1.Text Text1 is where you type in your text. Me refers to the control with the focus. You can use this in either the OnChange or AfterUpdate events lwells
|
|
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > How to set a default value for a field in a form |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
