automatic update in quarter text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form where the OTDLdaTe text box is entered and woud like the the
quarter field to automaticly have the correct quarter entered. I currently
have to enter the "Quarter"
I do not know where to start and in which text box use.
Quarter 1 = 01/01/2*** and < 04/01/2*** and so on.
 
Assuming the date's in text box txtDate, set the control source of text box
txtQuarter to =DatePart("q", Me.txtDate)

Note that this will only display the quarter on the form: you will not be
storing the quarter in the underlying recordset, which is the way it should
be: you shouldn't be storing calculated data in the table.
 
Back
Top