Form with Subform Help

[sandi8581]

Please help!

I am trying to create a data entry form for tracking employee labor hours. I would like to be able enter one pay period at a time for each employee. On my main form, I have employee ID # and Employee Last Name and First Name. On the subform, I have pay period #, charge account, actual hours, and factored hours.

The file is attached. The form is named frmTest.

Please help! I am new at this, so I'd appreciate any suggestions...

Sandi

 

[sandi8581]

Attachment

This is the file...it was created in Access 2000.

 

[Incisor]

I will take a look at this tonight. I am notoriously slow, so some Guru will likely have an answer for you before I manage to post.

 

[Incisor]

hi Sandi8581,

The sub form was a pain so I brewed my own solution. It's not fancy but it works.

I build a sql staement from the combo entries based on the time sheet table. Then I use the resulting query txt to change the record source propeerty for the form. When the button is clicked presto.

a default record source should be set to avoid #Name?.

But I wil leave that stuff to you.

hope it helps and is not too hokey.

Incisor