I'm really confussed. I'm doing the code in the "code builder" bit?...
Can some one please give me example of the coding? :(
I'm not trying to do anything to the main form, Just the Sub-Form on it. :/
:confused:
I have a form, which has a sub-form.
One of the columms has a tick box
when I tick this tick box I want 3 of the columns to appear
when its unchecked I don't want them to appear
what code do i use, its confusing.
I can do it on a non-subform cos i can make it "visable - no" then write a code...
just relised what i asked up there ^ is wrong
I want to do it so the area required appears in all of the products apart from one of them? how do i go about doing that, if thats possible (in the quanity column) & then the primeter to only appear for one patricular product
YAYAYAYA it works thank you so so so much :)
(i was putting it in the dicount field not ammount discount) silly me!
can you please help me with one more thingy
ive just done a screen shot
right ya no at the top where it says area whats the forumla so the number i type in there comes in the...
yay thankssss:)
the ones when their isnt check boxes work fine but where there is it says #Error and also it doesnt let me type anything in the discoutn collumn now?
thanks yeah carpet or nots thingy is carper or not cos of a stupid typo
i changed it to this and it says
#Name? :( & also i shud be able to type any number i want in the discount
http://i161.photobucket.com/albums/t226/Hifi17/die.jpg
from the ^ link ^
when you type in a value in the discount column it calculates it for all of the rows
how do i do it so it only does it for the rows that only have the tick box ticked
well...
i have a combo box on the main form [combo44]
and in the subform i have a column which shows the value i select from the drop down list, this value goes in all of the rows in the column.
i have another column which has a check box - some of the boxes in the rows are checked - some arent...
On the mainform i have a combo box.
when i select something from this combo box, it goes in to one of the columns on the subform - how do i get this so it only goes in certain rows?
I have column with a checkbox and it is ticked for the rows i want it in.
what do I have to do, to make it do...
OMG THANK YOU SO MUCH :) Its work :D yay
this is now appearing in all of rows of this column, do you know how to do it so it only appearing in the ones which have a tick box in another column?
heya, can someone please help me?
right, so i have a form which i made. and there is a sub form.
i have created a drop down list with - 0% 5% 10% 15% and 20%, on the mainform
i added a new column to the sub form and put =[combo42] because this is what the combo box was called
but it says...