Form / Subform in Access 1

[kastaman]

I have a form that has some repetitive entries which I would like to reduce, this is the date field.

My form consists of date, employee, # of calls + 5 others. We have a hardcopy report that is needs to be keyed in.

I though of a main form that contained the date and a subform (tabular)that contained the rest of the fields.

Firstly - is this a good concept? IF not, what can be proposed.

Secondly - I tried to create the main/subform with the date as the parent/child link but whenever I fill in the date from the main form, I cannot tab to the subform's fields.
any thoughts on this one?

Thanks in advance,

Kastaman

 

[tomschafer]

Try removing the Master/Child field links and setting the RowSource of the SubForm to. Note-change the blue to the names of the objects in your db...

select
*
from
TableName
where
Date=Forms!MainFormName!DateName