posted yesterday to no avail

I have a few quick questions.

1)on a products list, some products contain sub assemblies. This table is
used by a user constructing an order with boolean fields to select products.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9806-posted-yesterday-to-no-avail.html
If products B and C are sub-components of product A, is there any way to have
B and C automatically selected if A is selected? If you have idea for coding,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9806
please let me know exact terms/exactly where i would put it/ and how to call
any necessary terms

2)Along the same lines, if product C is a necessary component of A, but not
on a sub data sheet, is there any way to automatically select C when A is
selected? In other words, on a list of products, some go hand in hand. I
need to make sure that if one is checked, another one is as well. How can i
do this? again, i am programming illiterate, so please be explicit!

3)one last question....is there any way to hide sub data sheets for products
that do not contain sub assemblies? or at least hide the "+" next to the
product, to make it clear that there are not any further components?

help on any of these issues would be hugely appreciated!!

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Question 1

in the afterupdate for product A (if they are check boxes)

me.productB = me.productA
me.productC = me.productA
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9806

If A in turned on then B and C will be also and vise versa.

Question 2
It seems as if this is a repeat of question 1. If it is not then I need
more information to distinguish they two conditions.

Question 3
I don't believe so in the way that these forms are being shown. I looks
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9806
as if you have a datasheet view and a subform on that. The + says there
is a subform (with or without data)

Ron

Thanks for your help! the difference with my second question is that product
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9806
C is no longer a sub - component of product A. They are on the same table.
My guess is what you said will still work for this. My only question is
WHERE to put in this code? and how will it be executed? from a macro?

"Ron2006" wrote:

> Question 1
>
> in the afterupdate for product A (if they are check boxes)
>
> me.productB = me.productA
> me.productC = me.productA
>
> If A in turned on then B and C will be also and vise versa.
>
> Question 2
> It seems as if this is a repeat of question 1. If it is not then I need
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9806
> more information to distinguish they two conditions.
>
> Question 3
> I don't believe so in the way that these forms are being shown. I looks
> as if you have a datasheet view and a subform on that. The + says there
> is a subform (with or without data)
>
> Ron
>
>

You would put this code on the form in the afterupdate event for field
product A (if they are check boxes)

Right click on the field ProductA
Go to Properties
Go to event
Go to Afterupdate
click on the (....) on the right hand side
if it comes up select "code Builder"

add the following code (this assumes that the field names are productA
productB and productC. (the field name is under the Other tab of the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9806
properties for the field)

me.productB = me.productA
me.productC = me.productA

The above would work for question 1.

However, from the information so far I cannot see how you can
distinguish situation 1 form situation 2 when you are clicking product
A.

You can also go the other way for product C so that if you pick product
C it can make product A checked. But then you would have to go back and
revisit A if this were not the situation.

No macro is necessary, The after update event will be triggered
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9806
whenever you change the value in A.

thank you so much for your help.....the last part that i'm not getting:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9806

when you say right click on the field, are you talking about a
table/query/form?



> You would put this code on the form in the afterupdate event for field
> product A (if they are check boxes)
>
> Right click on the field ProductA
> Go to Properties
> Go to event
> Go to Afterupdate
> click on the (....) on the right hand side
> if it comes up select "code Builder"
>
> add the following code (this assumes that the field names are productA
> productB and productC. (the field name is under the Other tab of the
> properties for the field)
>
> me.productB = me.productA
> me.productC = me.productA
>
> The above would work for question 1.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9806
>
> However, from the information so far I cannot see how you can
> distinguish situation 1 form situation 2 when you are clicking product
> A.
>
> You can also go the other way for product C so that if you pick product
> C it can make product A checked. But then you would have to go back and
> revisit A if this were not the situation.
>
> No macro is necessary, The after update event will be triggered
> whenever you change the value in A.
>
>

The field on the form when looking at the form in design view.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9806