Lots of Luck To you!!!

  • Thread starter Thread starter DazedConfused
  • Start date Start date
D

DazedConfused

I had this same exact problem and Still do. I ask for assistance and
recieved the same cookie-cutter answer, and it does NOT work. I tried every
concivable way to place the code in and Never did get it to work.
If the answer ever comes out I would like to hear it.

Thanks
 
DazedConfused said:
I had this same exact problem and Still do. I ask for assistance and
recieved the same cookie-cutter answer, and it does NOT work. I tried
every concivable way to place the code in and Never did get it to
work.
If the answer ever comes out I would like to hear it.

Thanks
Click to expand...

I can't associate this reply with any thread, so I can't tell what
problem you have. If you got an answer that didn't work for you, did
you post a reply to that answer so that your respondent could suggest
something else?
 
I had this same exact problem and Still do. I ask for assistance and
recieved the same cookie-cutter answer, and it does NOT work. I tried every
concivable way to place the code in and Never did get it to work.
If the answer ever comes out I would like to hear it.

Thanks
Click to expand...

Someone might have a bit of a chance to help you if you had indicated
what problem you were trying to solve, or what message you were
responding to. As it is I have no way to determine either.
 
Here is the problem I was implying to: I this is "Fixed" I can get mine to
work because I have the exact same problem.
I tried every concivable code arrangement to try to get this to work, and it
would not.
Of course my Forms and fields were slightly different. I also came up with
the #error? message.

Hope this helps.
 
Sorry Here is the messages I was refering....

here's what i have for the conrol source [forms]![purchase
orders]![subcontrol1]![text16]

text 16 is the conrol on the sub form that i want displayed on the main
form. I get a #error on the main form.
---------------

Well assuming that "subcontrol1" is the name of the *control itself* and NOT
the name of the subform, the control source should be:
=[forms]![purchase orders]![subcontrol1].Form![text16]
---------------

that is correct. The control is name subcontrol1 and the name of the
subform is shipping cost. i have the control source set to [forms]![purchase
orders]![subcontrol1]![text16].

text16 is set to =sum(freight+purchase price+other+credit) which is in the
form footer which is the sum of the total cost for shipping.

I still get an error.
---------------

I got it to work in form view. But it won't work in datasheet view. Why
is this and how can I correct it.

-END MESSAGES--
Hope this helps
 
DazedConfused said:
Sorry Here is the messages I was refering....

here's what i have for the conrol source [forms]![purchase
orders]![subcontrol1]![text16]

text 16 is the conrol on the sub form that i want displayed on the
main form. I get a #error on the main form.
---------------

Well assuming that "subcontrol1" is the name of the *control itself*
and NOT the name of the subform, the control source should be:
=[forms]![purchase orders]![subcontrol1].Form![text16]
---------------

that is correct. The control is name subcontrol1 and the name of the
subform is shipping cost. i have the control source set to
[forms]![purchase orders]![subcontrol1]![text16].

text16 is set to =sum(freight+purchase price+other+credit) which is
in the form footer which is the sum of the total cost for shipping.

I still get an error.
Click to expand...

I wasn't aware of this, and I haven't yet found confirmation of it, but
it looks as though calculated controls on main forms that refer to
control on a subform just don't work when the main form is in datasheet
view. I tried a very simple case, and got #Error in that column for all
records on the main form.

This may or may not be a documented behavior, and it may or may not be
considered a bug. As I said, I haven't yet found anything about it.
However, the best workaround I can suggest at the moment is not to use
datasheet view for the main form. use Continuous Forms view instead.
If you want, you can format it in such a way that it looks a lot like
datasheet view.
 
Back
Top