Hello,
So what I have is a main form, containing navigation tabs, and one of those navigation tabs contains a form, with twelve more navigation tabs (one for each month).
We use this to track attendance for our employees.
Each field in my datasheet
Code:
Forms!frmMain!fsubNav.Form!fsubDatasheet
represents a shift.
When I load the database, and switch into the attendance tab, I want the horizontal scroll bar to scroll over so that the first field (minus the field containing employees, which I have frozen) (so I guess that means the second field) is the field representing the current, or next shift.
For example. If I opened up the database today, the first field would be employee name, the second field would the field representing Tuesday the 26th.
Don't worry about obtaining the name of the current shift, I can do that no problem.
I'm just looking for VBA that will move the horizontal bar over to a certain field.