N
Nick M
This question could go here,Macros, Form Programming, or Programming, forgive me if this is not the place for it.
I am tasked with calculating a control on a continunous form (well, continuous subform, to be exact.) The different variables are other controls that are bound to fields of one table mutliplied with a DLOOKUP that grabs the last variable of another table.
I have two problems: one is, whenever I try to add the DLOOKUP, the whole thing fails. The second proble is that, when I take out the DLOOKUP and just try to run a calculation by running the (sub)form, it calculates the control for the first record only; the other instances of the the control for the other record merely display that first calculated value.
I've tried to complete this task with macros; that hasn't worked (I get the standard 'macro failed' error). I wouldn't even know what event to tie it to. Even though I am a passable VB programmer, I don't want to go there because my boss wants as little of this done programmatically as possible (and it sounds like a lot of work.) Does anyone have an idea what i need to do to get this thing to do what I want?
Much Humble Thanks in Advance,
Nick M
I am tasked with calculating a control on a continunous form (well, continuous subform, to be exact.) The different variables are other controls that are bound to fields of one table mutliplied with a DLOOKUP that grabs the last variable of another table.
I have two problems: one is, whenever I try to add the DLOOKUP, the whole thing fails. The second proble is that, when I take out the DLOOKUP and just try to run a calculation by running the (sub)form, it calculates the control for the first record only; the other instances of the the control for the other record merely display that first calculated value.
I've tried to complete this task with macros; that hasn't worked (I get the standard 'macro failed' error). I wouldn't even know what event to tie it to. Even though I am a passable VB programmer, I don't want to go there because my boss wants as little of this done programmatically as possible (and it sounds like a lot of work.) Does anyone have an idea what i need to do to get this thing to do what I want?
Much Humble Thanks in Advance,
Nick M