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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Enter quarter automaticly based on date entered 4
Update quarter based on date entered 1
Pick Year and Pick Quarter 1
update subform from value in another form 2
Report/Query not selecting specific records 6
If . . . Then . . . Else statement (date) 6
Update Table Value Based Upon Form Entry 1
checking for duplicates 1

Back
Top