Re: Making bound field value equal other field value

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hello Jeff,

Yes I need to store this calculated data in my table. I have a sub form
that allows users to track the checks that are paid to a vendor. At the
bottom of the subform the total is shown. I need this total to be
transferred to a bound field on the main form. I have tried to set the After
Update event of the subform to trigger the change but it seems to only work
if I go back and type numbers in twice - odd. I can also create a public
variable in a module and store the total from the sub form to that and
transfer it. What I am having a problem with is figuring out what event to
use to trigger this transfer. Any suggestions would be greatly appreciated.

Rob

"Jeff Boyce" wrote:

Why do you 'really need' this? Are you trying to save the calculated value
in a table? If so, it is rarely necessary to save a value that can be
calculated from other data you already store.

If you'll explain more about your underlying data and situation, it may be
that you can do what needs to happen without saving calculated data.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Rob" <Rob@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A7EBF38E-A0B7-45FA-92FA-FA086C7E3302@xxxxxxxxxxxxxxxx
Hello All,

I have a form and a subform. When the subform is updated I get a total of
a
specific field and can transfer that total to my main form and make an
unbound field equal that total. I really need one of the fields (bound)
in
my main form to equal that total. How can I make a bound field equal that
total from the subform?

Thanks,

Rob



.

Relevant Pages

  • Re: can i use a subform for adding records in table
    ... Jon wrote: ... What I meant is who to store the records at the sub form into another ... Like any other form a subform will save its data ...
    (microsoft.public.access.forms)
  • RE: Attention Ken Sheridan
    ... store and the loacation of that store, which is a drop downlist ... damage, how much he needs to repay(as we pay off all the claims then deduct ... I am not sure what you mean by the city and state and having a seperate city ... works subform within a claims form, ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Attention Ken Sheridan
    ... store and the loacation of that store, which is a drop downlist ... damage, how much he needs to repay(as we pay off all the claims then deduct ... I am not sure what you mean by the city and state and having a seperate city ... works subform within a claims form, ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Attention Ken Sheridan
    ... store and the loacation of that store, which is a drop downlist ... damage, how much he needs to repay(as we pay off all the claims then deduct ... I am not sure what you mean by the city and state and having a seperate city ... works subform within a claims form, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: subform combobox filter problem
    ... > I have created a bound subform on an unbound masterform linked ... > an unbound combobox on the masterform and an invisible field on the ... what you see when you select a store is a list ... > subform's query (simple query on a single table sorting items ...
    (comp.databases.ms-access)