Form that changes dafualt value in a table

[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!

 

[OldPro]

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!

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.

 

[Jone]

I’m sorry, I’m new to this please be more specific.

 

[Jone]

What do you meen "set the default in the textbox control on the Add screen."
what's the code for that?