Updating

  • Thread starter Thread starter rob p
  • Start date Start date
R

rob p

I have a table that only stores a date in this format: 09/09/2003. I took a
version of the NWind Switchboard and have my record source for that form
tablecheckdate (I also tried querycheckdate) with a corresponding text box.

Anyway, I want to enter the date into the text box on the top of the form
and then tab to one of the four command buttons. My problem is getting the
table to update as soon as I tab out of the text box date field. How should
I do this? Of the four command buttons, I may be going to any of them after
putting in the date.

Hope this make sense.
thanks.
 
rob p said:
I have a table that only stores a date in this format: 09/09/2003. I
took a version of the NWind Switchboard and have my record source for
that form tablecheckdate (I also tried querycheckdate) with a
corresponding text box.

Anyway, I want to enter the date into the text box on the top of the
form and then tab to one of the four command buttons. My problem is
getting the table to update as soon as I tab out of the text box date
field. How should I do this? Of the four command buttons, I may be
going to any of them after putting in the date.

Hope this make sense.
thanks.
Click to expand...

Put this code as the AfterUpdate event procedure for the text box:

Private Sub txtCheckDate_AfterUpdate()

RunCommand acCmdSaveRecord

End Sub
 
Back
Top