the buttons that are Last Week & Week Before Last already have a start & stop (mon - fri)
now my problem is for buttons that populate only one field at a time. i have a button for today (current date). now i need to get my field filled by that button. but which one? the one the user pickes. so i used PreviousControl to find last Focus. heres what i did...
If Screen.PreviousControl = Me!txtDateTo Or Me!txtDateFrom Then
Screen.ActiveControl = Date
so with this code now the user can select the field to fill and then press the button to populate it. that part works good, and thats what i want. now i need to do something with the other part of it. THE ELSE PART. i need an Else to handle the times when focus is not a text box & is not a correct text box. every time another button has the focus when the code is ran, it errors.
im not sure what i need to handle the other input fields on the form and also the buttons when they have focus. anybody know how i can fix this?