Changing Text to Default Value if text already has a value in it

[nocty]

Hello,

I am a student working on a project. My group has ran into a problem, one of
the requirements is to open a form that has a feild called
Completed_Order_Date, it asks to set the value to current date if the text is
null, I used =date() as the default value yet my test data that I entered
still comes up null. How do I enter the system date in a null value?

Also the other requirement is to change the order_status which is a combo box
from Pending or Active to "Completed" which is the default value of 4 in our
list. The preexisting value still shows up as Active or Pending when I want
it to show up as completed. Any help would be awesome.

Thanks
Justin

 

[Arvin Meyer [MVP]]

Hello,

I am a student working on a project. My group has ran into a problem, one
of
the requirements is to open a form that has a feild called
Completed_Order_Date, it asks to set the value to current date if the text
is
null, I used =date() as the default value yet my test data that I entered
still comes up null. How do I enter the system date in a null value?

You can use a calendar, like the one at:

http://www.datastrat.com/Download/Calendar2K.zip

or put some code in a button, like:

Private Sub cmdDate()
Me.txtNameOfControl = Date()
End Sub

Also the other requirement is to change the order_status which is a combo
box
from Pending or Active to "Completed" which is the default value of 4 in
our
list. The preexisting value still shows up as Active or Pending when I
want
it to show up as completed. Any help would be awesome.

Similar code to the above, but to write it for you, I need to know which
event triggers the change to Completed.