Form that changes dafualt value in a table

  • Thread starter Thread starter Jone
  • Start date Start date
J

Jone

Hi I made a form that has a text box and a command button, and I want to be
able to change the default value in a table, for example the default value in
field “price†is $2.00 I want to be able to change it to $3.00 by typing it
in my form without have to going to the table design view.
So if you got some code for my command button please reply.
Thank You!
 
Hi I made a form that has a text box and a command button, and I want to be
able to change the default value in a table, for example the default value in
field "price" is $2.00 I want to be able to change it to $3.00 by typing it
in my form without have to going to the table design view.
So if you got some code for my command button please reply.
Thank You!
Click to expand...

There may be a way to change this property of the table, but I
wouldn't recommend it. Instead, allow the default to be NULL and do a
NZ(someField,cMinimumAmount) in code to set the default. Or, simply
set the default in the textbox control on the Add screen.
 
What do you meen "set the default in the textbox control on the Add screen."
what's the code for that?
 
Back
Top