Sharon Hague
Registered User.
- Local time
- Today, 15:32
- Joined
- Jul 10, 2003
- Messages
- 138
Hi All
Is there any way to set "auto date" in a form?
I have a table with 3 fields - Date, Initials & Overtime which has all our employee overtime listed. I have created a query based on this table sorted in date ascending order and entered a parameter field [Enter Initials] so that it shows all overtime for that employee.
I have now created a form (tabular) from this query for the entry of all the overtime for an employee but this is not updated on a daily basis - I only enter this once a month, so I can't use the now() option. Therefore when I am going to enter new entries it shows all previous entries and when I go to enter a new record I want it to automatically jump to the next date from my previous entry so that I don't have to type the date in every time.
Is this possible?
I'd appreciate anybody's help on this as it's driving mw mad with the amount of emloyee's we have.
Cheers.
Is there any way to set "auto date" in a form?
I have a table with 3 fields - Date, Initials & Overtime which has all our employee overtime listed. I have created a query based on this table sorted in date ascending order and entered a parameter field [Enter Initials] so that it shows all overtime for that employee.
I have now created a form (tabular) from this query for the entry of all the overtime for an employee but this is not updated on a daily basis - I only enter this once a month, so I can't use the now() option. Therefore when I am going to enter new entries it shows all previous entries and when I go to enter a new record I want it to automatically jump to the next date from my previous entry so that I don't have to type the date in every time.
Is this possible?
I'd appreciate anybody's help on this as it's driving mw mad with the amount of emloyee's we have.
Cheers.
