I have one main form were user have an option to select a criteria from the drop down.
The criteria table contains the CriteriaType as one column/filed and other 130 fields (say filed F1 through F 130 that are Yes/No check box)
CriteriaType F1 F2 F3 F4 F5 F6 F7 F8 ………F130
C1 Y N Y Y Y N N Y Y
C2 Y N Y N Y N Y Y Y
C25 N Y N Y N N N Y N
C267 Y N Y N Y N Y Y Y
I have another table for Product information that has ProductCode as one filed and the same F1 through F130 fields from the criteria table but it is text box not Yes/no filed
ProductCode F1 F2 F3 F4 F5 F6 F7 F8 ………F130
P1 xxxx sdaf dff
P34 df dff gdf kllf
I want to enter product code filed F1 through F130 based on criteria table, in other words , if user selects CriteriaType from the drop down it will display only the Y fields from the product information table
Example :
User selects C25 then on product information form only fields F2,F4 and F8 will be visible and other fields will be invisible
What I have done:
Created a main form (based on product information table) to add product information based on pre defined criteria and I created a sub form based on the CriteriaType table and queried it so that if drop down selection will filter the required criteria in criteria sub form and on main form I have all fields F1 through F130. If user want to add new ProductCode they will select criteria and I want to show only the required field ( I have written code that --- If F1 on sub form is true then F1 on main form is visible else it is not visible and so on till F130 )
My Problem: I have column based form and my code works fine to show and hide the required filed but form leaves white space that I want to eliminate
If say filed F1 , F4 and F130 are visible it leaves a huge gap between them
I have change Can Shrink property to YES in details but the form still shows white space
I have more than 200 criteria’s and I don’t want o create 200 sub forms
Does any one know a better way to eliminate the white space on form or re-arrange the fields based on my criteria
Thanks
Rahul
The criteria table contains the CriteriaType as one column/filed and other 130 fields (say filed F1 through F 130 that are Yes/No check box)
CriteriaType F1 F2 F3 F4 F5 F6 F7 F8 ………F130
C1 Y N Y Y Y N N Y Y
C2 Y N Y N Y N Y Y Y
C25 N Y N Y N N N Y N
C267 Y N Y N Y N Y Y Y
I have another table for Product information that has ProductCode as one filed and the same F1 through F130 fields from the criteria table but it is text box not Yes/no filed
ProductCode F1 F2 F3 F4 F5 F6 F7 F8 ………F130
P1 xxxx sdaf dff
P34 df dff gdf kllf
I want to enter product code filed F1 through F130 based on criteria table, in other words , if user selects CriteriaType from the drop down it will display only the Y fields from the product information table
Example :
User selects C25 then on product information form only fields F2,F4 and F8 will be visible and other fields will be invisible
What I have done:
Created a main form (based on product information table) to add product information based on pre defined criteria and I created a sub form based on the CriteriaType table and queried it so that if drop down selection will filter the required criteria in criteria sub form and on main form I have all fields F1 through F130. If user want to add new ProductCode they will select criteria and I want to show only the required field ( I have written code that --- If F1 on sub form is true then F1 on main form is visible else it is not visible and so on till F130 )
My Problem: I have column based form and my code works fine to show and hide the required filed but form leaves white space that I want to eliminate
If say filed F1 , F4 and F130 are visible it leaves a huge gap between them
I have change Can Shrink property to YES in details but the form still shows white space
I have more than 200 criteria’s and I don’t want o create 200 sub forms
Does any one know a better way to eliminate the white space on form or re-arrange the fields based on my criteria
Thanks
Rahul
