Disable field based on value in another field

[AWithers]

I am preparing a continous forms sub-form to present historic revenue data /account (since jan 01) and also to capture revenue estimations going forward to the end of 2003

The format is

12 monthly rows, 3 columns headings i.e. 2001, 2002 and 2003.

I want to ensure that no historic record can be changed but are available to view, this is easy enough for 2001 (i.e. disable the control) but I want to disable the fields for months 1 to 7 for 2002 but ensure that 8 to 12 inclusive are avaiable for input

The disablement needs to be done on a row by row basis...any ideas?

Andy

 

[scriverb]

Hello Andy, you have posted quite a problem. If you are using A97 I am pretty sure that you cannot do what you want to do. You see on a continuous subform the property changes of a control apply to all of the rows being displayed. I believe you want different controls to be disabled depending on the data for that record.

Now if you are using A2000 or better I have read in this forum and others that there are properties that you can use to set the properties of controls for an individual record/row. Their comments were releated to control formatting as it related to back/fore colors and bolding I believe. But, I took it from the comments it would releated to other properties of the controls on that row. Since I am not using A2000 I can't speak directly to how to do this but maybe someone else can assist you.

Good luck. Hopefully someone else will take this a step further for you.
Bob Scriver

 

[Sylv4n]

can i ask why are you using a contious form?

why not set up 12 text boxes down and x text boxes accross. then you will be able to lock them on ofmr open by using code

just a thought

 

[AWithers]

Thanks for your responses(I'm using Access 97), I didnt think there was a simple answer. I need to have the db finished today and i simplified the problem (i actually have 3 boxes/month/year and thus I will need to code a lot of boxes, a subform was the simplest quickest answer using the data structure.

My fall-back position is to check for changes to the historic data at the end of the exercise and update them back to the original values

Thanks

Andy