Setting default date value

[Anthrax]

I have a button in a form that brings the user to a table to add a new record. I want the feild of "dates" to be automaticlly populated with a value that is 7 days after the previous date in the feild.

the code i have currently is

Private Sub Command14_Click()
DoCmd.OpenTable "Cincinnati Time Sheet", acViewNormal

DoCmd.GoToRecord , , acNewRec
End Sub

 

[spikepl]

1. For input only forms are used so that you can safeguard the data and prevent users from wiping out stuff. Make a form based on your table. In that form you can do all kinds of manipulation.
2. "Cincinatti Time Sheet" implies that you have separate tables with time sheets for each location. This is a normalization error - google database normalization. The same type of data goes into the same container, but just with a tag to identify it.

 

[Anthrax]

Id really like to normalize the database better, trust me I would. I really am just having trouble meeting the functional requirements that have been given to me with a properly normalized database.