Record selector on a sub-form

[kaltman]

I have entry form 1; the record source is W1 timesheet.
The first control is W1 Day1 (first day of the pay period).

The sub form is W2 entry form; the record source is W2 timesheet.
I am linking the child to the master using Employee#.
The first control is W2 Day1 (first day of the second week).

My problem is this: If an employee enters W1 Day1 and doesn't enter W2
Day1's date, then the auto ID # on the two tables the timesheets are entered
into will not match up, and then the timesheet reports can not print out
correctly.

The sub form has its own record selector.
What I would like is this: When the employee enters W1 Day1 date, I would
like the sub form to automatically fill in W2 Day1 date, to reserve the
correct auto numbering in the table. Also, I would like the employee to be
able to use the record selector on the Master entry form and have the Child
entry form follow that instead of having it's own record selector.

I hope this all makes sense.
Thank you in advance for your help.

 

[Jeff Boyce]

It sounds like you are saying that you are trying to get Access Autonumber
IDs in two separate tables to match up.

If so, DON'T! Access Autonumbers are intended for use as unique row
identifiers, and every table's Autonumber/ID is independent of any other
table's autonumber.

Or have I misunderstood?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[kaltman]

Yes, I guess that's what I'm trying to do. My problem is that we are going
from entering one-week timesheet per report, to a two-week timesheet per
report. One table does not allow enough enteries for two weeks worth of
input, so I had to divide each week into two separate tables. Then I would
build a query looking at both tables to be able to print one report with two
weeks worth of time on it. I feel like I'm getting myself into a bigger and
bigger whole.

 

[Douglas J. Steele]

"One table does not allow enough enteries for two weeks worth of input"

Sounds as though you've got fields like MondayStartTime, MondayEndTime,
MondayLunchStart, MondayLunchEnd. That's definitely wrong. Each day should
be a separate row in a table.