Autofill

[Guest]

I working with an employee time entry database. I'm entering time week-long
sheets. As the database is set up now, I open one form, enter the employee
through a drop-down and then enter A date. I then have to open another form
and enter all of the work for that date, then close that form, return to the
other and enter a new date. I want to be able to stay in the second form and
fill in an entire week at a time however, I would like to know how to enter a
date once in a date field and have it "repeat/autofill" that date until I
change the data in the date field. As opposed to entering the date in every
new record. If you have a solution, please humor me and provide specific
directions as to how and where to enter the necessary code, etc. I know how
to move around in "properties" and where to enter code but the more specific
the more appreciated.
Thank you.

 

[Guest]

A subform instead of the second form would be a much better approach. If the
table that has the times in it has the employee id and the date as fields,
then you can use the Link Master Fields and Link Child Fields properties of
the subform control to link the employee and date from your main form to
child records in your subform. This will cause both of those fields to be
populated automatically.

The basics are:
Create a form for entering the time with the table that stores that data (or
a query based on that table). You will want the default view to be either
continuous or datasheet view.

Create a subform control on your main form.
Make new form the SourceObject of the subform control.
Establish the Master/Child Links as described previously.

If you need any additional assistance with this, post back.