Default Date In A Form

[scubagal]

I would like to have the current date in the date box on a form that is open throughout the day. Is it possible and if so, can someone tell me how to do it? Thanks

[RuralGuy]

Set the ControlSource of the TextBox to: =Date()

[scubagal]

Thanks. That was an easy one for you. How about this.... I want my form to open with the last entry showing instead of the very first. Can you help me with that? Thanks.

[RuralGuy]

Is it a single form, continuous form or datasheet view?

[scubagal]

Yes it is a single form, in datasheet view and it continues on from 1 day to the next.

[RuralGuy]

Datasheet View shows all of the records in the RecordSource. What is it you want to do, scroll down to the last record?

[scubagal]

Right now when the form opens, (the forms opens automatically when the db is launched), the very first record is showing. I would like it so that when it opens the very last record is showing. I guess this means it is in form view.

[RuralGuy]

Put this in the OnLoad Event procedure.
Private Sub Form_Load()
DoCmd.RunCommand acCmdRecordsGoToLast
End Sub