Pat,
Thanks for your help thus far, but I still need a lot of help, as I still don't understand this, so please try to help if you can:
When the first person enters information, the date is not included in the entry (in the table), also the date is not displayed until the second entry (in the form), so it seems as if it needs to be displayed in order to be updated (As of right now, it only works when the date is displayed). Also, how is it innaccurate to display the date on the form, if the date isn't entered into the table until the user actually submits the information?
Also, regarding:
--------------------------------------------
As to the rest of the fields, if you don't want them to show when the form is opened to a new record, remove the default values. Then in the BeforeUpdate event of the Form put code to populate the empty fields:
If Len(Trim(Me.txtYourFld)) = 0 Then
Me.YourFld = "some default value"
End If
--------------------------------------------
There were no default values in the text boxes that I don't want to display to begin with, but they still display. And, I tried getting the code to work, but it didn't. If I have a text box titled CustomerNum, should I somehow rename it txtCustomerNum, or would I put:
If Len(Trim(Me.txtCustomerNum)) = 0 Then
Me.YourFld = "some default value"
End If
And what default value should I put if I don't want the values to show up?
Also to DES, I went to the site, but I could not find an example of what I'm trying to accomplish.
**As is obvious I am pretty lost, and would like to send a DB example to anyone who is willing to help.
Thanks, and all the help thus far is greatly appreciated.