Manipulating Control Source 2nd Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On 7/27/05 I posted a question "Manipulating a control source" some
suggestions were made but I am still in a dark alley...Please Help

In this posting I changed the question around maybe this way I can get some
more help. (Pretty soon I will need Mental Help)

I have a text box (lets call it Total), in a tab page, with the control
source expression:

=IIf([Date]>0,[quant1]*1.5+[quant2]*4+[quant3]*5)

the values in "quant1, quant2, and so on" are text boxes in another tab page
in the same form.

So if:
quant1 is 45 (*1.5=67.5)
quant2 is 30 (*4=120)
quant3 is 0 (*5=0)
the expresion in the Total text box will be 187.5 but for X reason I want to
be able to click in the Total text box and change 187.5 to 307.5 but I cannot
change it. And thats my dilema. PLease Help, thanks in advance
 
That is because you have it in the control source. Move it to the default
value.
I also notice that your IIf statement appears to have to False value. It is
required and will return a compile error.
You need some value where ??? is to return if [Date]<=0
=IIf([Date]>0,[quant1]*1.5+[quant2]*4+[quant3]*5,???)
 
Set your code in the Default event and it will set it by the date if nothing
is input however it will accept your input if you have one. Either way
remember the type data being input must be consistent with the table setting.

Hope this helps.

Dwight
 
I think I discuss this with you and it didn't seem to work last
time...remember?

Klatuu said:
That is because you have it in the control source. Move it to the default
value.
I also notice that your IIf statement appears to have to False value. It is
required and will return a compile error.
You need some value where ??? is to return if [Date]<=0
=IIf([Date]>0,[quant1]*1.5+[quant2]*4+[quant3]*5,???)

coronacity said:
On 7/27/05 I posted a question "Manipulating a control source" some
suggestions were made but I am still in a dark alley...Please Help

In this posting I changed the question around maybe this way I can get some
more help. (Pretty soon I will need Mental Help)

I have a text box (lets call it Total), in a tab page, with the control
source expression:

=IIf([Date]>0,[quant1]*1.5+[quant2]*4+[quant3]*5)

the values in "quant1, quant2, and so on" are text boxes in another tab page
in the same form.

So if:
quant1 is 45 (*1.5=67.5)
quant2 is 30 (*4=120)
quant3 is 0 (*5=0)
the expresion in the Total text box will be 187.5 but for X reason I want to
be able to click in the Total text box and change 187.5 to 307.5 but I cannot
change it. And thats my dilema. PLease Help, thanks in advance
Click to expand...
Click to expand...
 
That was one of the suggestions given the first time around. But it doesn't
work like I want it to work. When I do change the total price it changes it
for all the records.

Hansford cornett said:
Set your code in the Default event and it will set it by the date if nothing
is input however it will accept your input if you have one. Either way
remember the type data being input must be consistent with the table setting.

Hope this helps.

Dwight
--
Hansford D. Cornett


coronacity said:
On 7/27/05 I posted a question "Manipulating a control source" some
suggestions were made but I am still in a dark alley...Please Help

In this posting I changed the question around maybe this way I can get some
more help. (Pretty soon I will need Mental Help)

I have a text box (lets call it Total), in a tab page, with the control
source expression:

=IIf([Date]>0,[quant1]*1.5+[quant2]*4+[quant3]*5)

the values in "quant1, quant2, and so on" are text boxes in another tab page
in the same form.

So if:
quant1 is 45 (*1.5=67.5)
quant2 is 30 (*4=120)
quant3 is 0 (*5=0)
the expresion in the Total text box will be 187.5 but for X reason I want to
be able to click in the Total text box and change 187.5 to 307.5 but I cannot
change it. And thats my dilema. PLease Help, thanks in advance
Click to expand...
Click to expand...
 
Back
Top