Dear sir,



I have a date table, which I would like to keep alot of dates in.  My 

studies which I am creating this database has many phrases, but in my 

forms I would only like to view certain dates. For example_



1. First Study - Startdate- StopDate- DueDate- CompleteDate

2. second Study- StartDate- StopDate

3. Thrid Study - StartDate-         - DueDate- CompleteDate



the first and third study have 60 days after they have been started to be 

completed. I have a table which shows the number, Name, days(60)-the 

second study shows a null value.



In my subtable I would like to write some code to show if study number 1 

is selected in my combo box then show all fields, but if number 2 is 

picked then only show Start and Stop field. Is this possible. or can I 

write code to fill in the blank fields with color so no one can populate 

them?



Thank you for your Help?

I suggest you use a combo box with select case. Also you probably might want

use a if/then statement.



Robert L. Rogers

Rexel Branch Electric

Application Developer

xxx-xxx-xxxx





-----Original Message-----

From: KennethMungwira [mailto:KennethMungwira@Y...]

Sent: Friday, October 12, 2001 11:25 AM

To: Access

Subject: [access] Hidden Certain Parts of tables due to Comb Box





Dear sir,



I have a date table, which I would like to keep alot of dates in.  My 

studies which I am creating this database has many phrases, but in my 

forms I would only like to view certain dates. For example_



1. First Study - Startdate- StopDate- DueDate- CompleteDate

2. second Study- StartDate- StopDate

3. Thrid Study - StartDate-         - DueDate- CompleteDate



the first and third study have 60 days after they have been started to be 

completed. I have a table which shows the number, Name, days(60)-the 

second study shows a null value.



In my subtable I would like to write some code to show if study number 1 

is selected in my combo box then show all fields, but if number 2 is 

picked then only show Start and Stop field. Is this possible. or can I 

write code to fill in the blank fields with color so no one can populate 

them?



Thank you for your Help?