Tranferring values from one form to another

[Guest]

Hi,

I am fairly new at using access and have been given the task of coming up
with a timekeeping database for a large company. I have a daily timesheet in
one form and a weekly timesheet in another. I would like the value for the
total hours on a certain day to automatically show up in the weekly form for
that day. I am baffled. Can someone please she some light?

Thanks,

Lynn

 

[Jeff Boyce]

Lynn

It sounds like you are trying to move data around on forms.

Access forms DISPLAY data, Access tables STORE data.

If you want to see data that was entered via form1 into table1 on form2,
make form2 look at table1. Queries work great for this.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[pietlinden]

Hi,

I am fairly new at using access and have been given the task of coming up
with a timekeeping database for a large company. I have a daily timesheet in
one form and a weekly timesheet in another. I would like the value for the
total hours on a certain day to automatically show up in the weekly form for
that day. I am baffled. Can someone please she some light?

Thanks,

Lynn

Once the data you enter is in the table the form is based on, you can
requery the second form's rowsource and the data will show up. Forms
don't contain any data at all. Tables do that. Forms just have
controls for making it easier to do data entry. Use reports and
queries for what you're talking about. (showing/summarizing data).

Otherwise, you could create an unbound control on your form. and set
the controlsource to a domain sum function... If you look up DSUM in
the help, there are examples. Also in NWind.