J
jackle
I have a funny situation that is causing an un-funny problem. I have a form
that has unbound fields that make up a timesheet "grid". This grid has monday
thru sunday wirth in times, out times, etc. this grid has expressions (or
formulas) that read data from the recordset that is bound to the form and
also makes totals. The recodset is 7 records, one for each day of the week.
Due to the parameter in the query structure, this represents only employee.
It works great in the form but I actually get 7 identical records instead of
1 form that has the data. this is a problem mainly because i print or export
a copy for e-mailing. i have to strip the other six unneccessary records. I
want to have only one form record that has all the fields. I'd hate to
transfer all the expressions (or formulas) into a querythat outputs 1 field
for each text box on the form. that would make 109 alias's with the
expressions. any tips. I thought about an unbound form but i can't figure how
to connect to the table or query without creating the 7 identical
forms-records.
any help is appreciated
jackle
that has unbound fields that make up a timesheet "grid". This grid has monday
thru sunday wirth in times, out times, etc. this grid has expressions (or
formulas) that read data from the recordset that is bound to the form and
also makes totals. The recodset is 7 records, one for each day of the week.
Due to the parameter in the query structure, this represents only employee.
It works great in the form but I actually get 7 identical records instead of
1 form that has the data. this is a problem mainly because i print or export
a copy for e-mailing. i have to strip the other six unneccessary records. I
want to have only one form record that has all the fields. I'd hate to
transfer all the expressions (or formulas) into a querythat outputs 1 field
for each text box on the form. that would make 109 alias's with the
expressions. any tips. I thought about an unbound form but i can't figure how
to connect to the table or query without creating the 7 identical
forms-records.
any help is appreciated
jackle