Re: Transfer Data From Pop Up to Main Form

Tech-Archive recommends: Speed Up your PC by fixing your registry

"JD McLeod" <JDMcLeod@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D65BD5F1-3E83-49DD-9BF2-0905FE14507B@xxxxxxxxxxxxxxxx
I have a form called "time ***". When the user wants to calculate the
total hours worked, they click on a command button that launches another
pop-up form "time calculation" which allows them to enter in the start and
ending time. It then calculates the total hours worked. I would like for
this data on "time calculation" to be transferred to the "total hours
worked"
field on the form "time ***" when the "time calculation" form is closed.
Any advice is much appreciated. Thanks.

Two ways:

1) - in the time calculation form on the close event, simply stuff values
back:

eg:

forms![time ***]!HoursWorkd = me!HoursWorked
forms![time ***]!DaysWorked = me!DaysWorked

etc.....

2) - open target form as acDialog, have you code wait until user is done,
and then
grab values from that form.
I explain this here:

http://www.members.shaw.ca/AlbertKallal/Dialog/Index.html


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@xxxxxxx



.

Quantcast